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>