<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><div>Remove the FILTERITEM, then I'd try FILTER "upper(parcel_no) like '%'||upper('%id%')||'%'"</div><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><br><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><font size="2" face="Tahoma"><b><span style="font-weight: bold;">From:</span></b> t faustino <geomatrix3d@gmail.com><br><b><span style="font-weight: bold;">To:</span></b> geomoose-users@lists.sourceforge.net<br><b><span style="font-weight: bold;">Sent:</span></b> Mon, August 2, 2010 9:23:50 AM<br><b><span style="font-weight: bold;">Subject:</span></b> [Geomoose-users] msPostGISLayerWhichShapes error<br></font><br>
OS: linux<br>Geomoose v1.6<br><br>When trying a search I'm getting this msPostGISLayerWhichShapes error result from itemquery.map;<br><br>Did a search query against my parcels layer on parcel # 059;<br><br><blockquote style="border-left:1px solid rgb(204, 204, 204);margin:0pt 0pt 0pt 0.8ex;padding-left:1ex;" class="gmail_quote">
msPostGISLayerWhichShapes(): Query error. Error (ERROR: syntax error at or near "^" LINE 1: ...9454.261772,2143616.71123 1209454.261772))',2240) and (^059) ^ ) <br>executing query: select "gid","map_no","dist","parcel_no","subpar","Par_id","Comments","Shape_Leng","Shape_Area","Rkey",encode(AsBinary(force_collection<br>
(force_2d("the_geom")),'NDR'),'hex') as geom,"gid" from "parcels" where the_geom && GeomFromText('POLYGON((2143616.71123 1209454.261772,2143616.71123 <br>1255434.854927,2200833.463198 1255434.854927,2200833.463198 1209454.261772,2143616.71123 1209454.261772))',2240) and (^059)<br>
</blockquote><br><br> Appears to not like the FILTER syntax; <br><br clear="all"><blockquote style="border-left:1px solid rgb(204, 204, 204);margin:0pt 0pt 0pt 0.8ex;padding-left:1ex;" class="gmail_quote">Itemquery.map:<br>
LAYER # Parcels Polygon Layer<br> NAME 'parcels'<br> CONNECTIONTYPE postgis<br> CONNECTION "dbname='*****' host=localhost port=5432 user='*****' password='*****' sslmode=prefer"<br>
DATA '"the_geom" FROM "parcels" using unique gid using srid=2240'<br> STATUS DEFAULT<br> TYPE POLYGON<br> METADATA<br> qstring_validation_pattern '.'<br>
END<br> TEMPLATE 'landrecords/itemquery_parcels.html'<br> FILTERITEM 'parcel_no'<br> FILTER /.*%id%.*/i #begins with search regular expression<br> END<br></blockquote><br><br>
Any advise anyone? <br><br><br>-- <br>"If one advances confidently in the direction of his dreams, and endeavors to live the life which he has imagined, he will meet with a success unexpected in common hours." ~Thoreau<br>
<br><br>
</div></div></blockquote><div style="position:fixed"></div>
</div><br>
</body></html>