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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
Website: www.houstonengineeringinc.com
--
Richard Greenwood
[EMAIL PROTECTED]
www.greenwoodmap.com
