[Geomoose-users] msPostGISLayerWhichShapes error

[t faustino]

OS: linux
Geomoose v1.6

When trying a search I'm getting this msPostGISLayerWhichShapes error result
from itemquery.map;

Did a search query against my parcels layer on parcel # 059;

msPostGISLayerWhichShapes(): Query error. Error (ERROR: syntax error at or
> near "^" LINE 1: ...9454.261772,2143616.71123 1209454.261772))',2240) and
> (^059) ^ )
> executing query: select
> "gid","map_no","dist","parcel_no","subpar","Par_id","Comments","Shape_Leng","Shape_Area","Rkey",encode(AsBinary(force_collection
> (force_2d("the_geom")),'NDR'),'hex') as geom,"gid" from "parcels" where
> the_geom && GeomFromText('POLYGON((2143616.71123
> 1209454.261772,2143616.71123
> 1255434.854927,2200833.463198 1255434.854927,2200833.463198
> 1209454.261772,2143616.71123 1209454.261772))',2240) and (^059)
>


  Appears to not like the FILTER syntax;

Itemquery.map:
> LAYER # Parcels Polygon Layer
>         NAME 'parcels'
>         CONNECTIONTYPE postgis
>         CONNECTION "dbname='*****' host=localhost port=5432 user='*****'
> password='*****' sslmode=prefer"
>         DATA '"the_geom" FROM "parcels" using unique gid using srid=2240'
>         STATUS DEFAULT
>         TYPE POLYGON
>         METADATA
>             qstring_validation_pattern '.'
>         END
>         TEMPLATE 'landrecords/itemquery_parcels.html'
>         FILTERITEM 'parcel_no'
>         FILTER /.*%id%.*/i   #begins with search regular expression
>   END
>


Any advise anyone?


-- 
"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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/geomoose-users/attachments/20100802/ec7084e9/attachment.html