<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<META content="MSHTML 6.00.6000.16981" name=GENERATOR></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>Using GM 1.6 at the moment:</DIV>
<DIV> </DIV>
<DIV>I am trying to pull field values from a join table (just a simple CSV file joined to my parcel shapefile) in order to provide access to utility account information on my Information tab of GeoMoose. When I try to pull the data from a field in the joined table in my itemquery.html file I get only the join field name I put into the HTML code (e.g. Test_Value). From what I can tell from the MapServer documentation the syntax for a join field is JOINNAME_FIELDNAME.</DIV>
<DIV> </DIV>
<DIV>I've created the join in my parcel map file and the parcel layer still displays, so I think my join syntax is correct. I haven't thought of another way to test whether the join worked or not, but assuming it has, can I pull field values from the joined table in an Item Query?</DIV>
<DIV> </DIV>
<DIV>In other words, does the GeoMoose Item Query count as a MapServer query that will activate the join?</DIV>
<DIV> </DIV>
<DIV>Thanks.</DIV>
<DIV> </DIV>
<DIV>Brian</DIV>
<DIV> </DIV>
<DIV>
<DIV><FONT color=#808080>--------</FONT></DIV>
<DIV><FONT color=#808080>Brian Welch, GIS Technician</FONT></DIV>
<DIV><FONT color=#808080>City of Northfield</FONT></DIV>
<DIV><FONT color=#808080>Northfield, MN 55057</FONT></DIV>
<DIV><FONT color=#808080>507-645-3027</FONT></DIV></DIV><BR>
<p>
<font size="2" color="#cc0000" face="Arial"><i>This message and any
attachments may contain confidential and /or proprietary information and
is intended for the person / entity to whom it was originally addressed.
Any use by others is strictly prohibited</i></font><i><font color="#cc0000" face="Times New Roman">
.</font></i>
</p>
</BODY></HTML>