<div>Jay,</div>
<div> </div>
<div>you must use FILTERITEM only for simple FILTER expressions (string comparison only)</div>
<div>for example: </div>
<div>FILTER "2005" ->fieldvalue<br>FILTERITEM "year" ->fieldname</div>
<div> </div>
<div>For Logical FILTER expressions you do not define FILTERITEM. In this case you must place the FILTER between parentheses, and fieldnames between brackets </div>
<div> </div>
<div>for example:</div>
<div>FILTER ([field1]<4000 AND "[field2]"=="Museum") -->observe quotes on both sides on text fields<br></div>
<div> </div>
<div>See <a href="http://mapserver.org/mapfile/expressions.html#expressions">http://mapserver.org/mapfile/expressions.html#expressions</a> for detail on how to build logical expressions</div>
<div> </div>
<div>Regards,</div>
<div>Emiliano<br></div>
<div class="gmail_quote">2009/12/10 Jay Kapalczynski <span dir="ltr"><<a href="mailto:jkapalczynski@ci.maple-grove.mn.us">jkapalczynski@ci.maple-grove.mn.us</a>></span><br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div lang="EN-US" vlink="purple" link="blue">
<div>
<p class="MsoNormal">I looked on map server website in the documentation and cant get the synstax correct</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">I have two textboxes idOwner and idOwner2</p>
<p class="MsoNormal">I am a bit confused on the FILTERITEM because I am trying to write the expression to include two fields.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">USE1_DESC and BLOCK are the two fields that form the query</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><span style="FONT-SIZE: 9pt; COLOR: #632423"> LAYER # Parcels Owner Layer</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 9pt; COLOR: #632423"> NAME 'Parcels'</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 9pt; COLOR: #632423"> DATA 'parcels/parcels.shp'</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 9pt; COLOR: #632423"> STATUS DEFAULT</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 9pt; COLOR: #632423"> TYPE POLYGON</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 9pt; COLOR: #632423"> METADATA</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 9pt; COLOR: #632423"> qstring_validation_pattern '.'</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 9pt; COLOR: #632423"> END</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 9pt; COLOR: #632423"> TEMPLATE 'parcels/itemquery_parcels_Owner.html'</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 9pt; COLOR: #632423"> </span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 9pt; COLOR: #632423"> FILTERITEM 'USE1_DESC'</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 9pt; COLOR: #632423"> </span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 9pt; COLOR: #632423"> FILTER (* WHERE USE1_DESC = '%idOwner%' and BLOCK = '%idOwner2%') </span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 9pt; COLOR: #632423"> </span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 9pt; COLOR: #632423"> END </span></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p></div></div><br>_______________________________________________<br>mapserver-users mailing list<br><a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Ing. Emiliano Castañeda<br>SUR Emprendimientos Tecnológicos<br><br>Ing. Huergo 1189 (C1007AOL)<br>Ciudad de Buenos Aires, Argentina<br>Tel. +54 (11) 5811-4552 ext. 107<br>
<a href="mailto:emilianocastaneda@suremptec.com.ar">emilianocastaneda@suremptec.com.ar</a><br><a href="http://www.suremptec.com">www.suremptec.com</a><br>