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