join with dbf file

Richard Greenwood richard.greenwood at GMAIL.COM
Sun May 13 14:57:15 PDT 2007


I don't totally follow what you are doing. Do you want a map with
multiple parcels highlited? If so, try putting the
"multi_parcel_selected.html" template in the  HEADER instead of the
TEMPLATE. This will group all parcels into one map, as opposed to
using the TEMPLATE, which will return a separate map for each parcel.

Rich

On 5/8/07, Fischer, Brian <bfischer at houstonengineeringinc.com> wrote:
>
>
> I am trying to do a one-to-many join to a .dbf file and am not getting the
> results I want.  I was wondering if anyone has had a similar problem.  I
> keep getting back one record with the my join table field not being
> replaced.  If I remove the template from the class object I don't get any
> features returned.  Do I have the join defined incorrectly?  Here is what my
> layer definition looks like and my HTML template.
>
> LAYER # Dummy Parcels Polygon Layer to Highlight it yellow
>     NAME parcel_query
>     DATA parcels
>     MAXSCALE 50000
>     MINSCALE 500
>     STATUS DEFAULT
>     HEADER 'header.html'
>     FOOTER 'footer.html'
>     JOIN
>         FROM "PIN"
>         NAME "MULTI"
>         TABLE
> "E:\mapdata\douglas_mn\LUT_MULTI_INTEREST.DBF"
>         TEMPLATE "multi_parcel_selected.html"
>         TO "MI_PIN"
>         TYPE ONE-TO-MANY
>     END
>     TYPE POLYGON
>     CLASSITEM 'CODE'
>     CLASS
>         NAME "Parcel Selected"
>         EXPRESSION "1"
>         TEMPLATE "parcel_selected.html"
>         SYMBOL 'plainline'
>         COLOR -1 -1 -1
>         OUTLINECOLOR 255 255 0
>         SIZE 4
>     END
>     CLASS
>           NAME "Multi-Interest Parcel"
>           EXPRESSION "3"
>           TEMPLATE "multi_parcel_selected.html"
>           SYMBOL 'plainline'
>           COLOR -1 -1 -1
>           OUTLINECOLOR 255 255 0
>           SIZE 4
>     END
>   END
>
>
> HTML Query Template:
> <tr>
> <td colspan="2">This is a multi interest property.</td>
> </tr>
> <tr>
> <td>PIN:</td>
> <td><a
> href='javascript:openwin("parceldetail","../parcelform.php?pin=[MULTI_PIN]")'>[MULTI_PIN]</a></td>
> </tr>
> <td colspan="2"><hr></td>
>
> Thanks,
> Brian
>
> Brian Fischer, CFM
> GIS Project Manager
> Houston Engineering, Inc. | Leave Nothing to ChanceTM
> 6901 East Fish Lake Road, Suite 140
> Maple Grove, MN 55369
> Phone:  763.493.4522 / Fax:  763.493.5572
> Email:  bfischer at houstonengineeringinc.com
> Website: www.houstonengineeringinc.com
>


-- 
Richard Greenwood
richard.greenwood at gmail.com
www.greenwoodmap.com



More information about the MapServer-users mailing list