[mapserver-users] Querying PostGIS layer attributes -> error

[Paul Ramsey]

There might be a nasty with respect to PHP. I know we have queries 
working fine in other contexts. Can you do a query using the normal 
mapserver cgi? Also, how old/new is your mapserver codebase?

Antti.Roppola at brs.gov.au wrote:
> Hi all,
> 
> I have PostGIS 0.7.1 built into Postgres 7.2.1 and it works
> as a data source for generating maps. However, running any
> queries against a PostGIS layer gives me an error (see below).
> 
> Is this a know issue, or am I doing something wrong? I have the
> same data and layer entry as a shape and it works fine.
> 
> Cheers,
> 
> Antti
> 
> 
> Fatal error: MapServer Error in msPOSTGISLayerGetShape(): Error executing POSTGIS SQL statement: DECLARE mycursor BINARY CURSOR FOR SELECT gid::text,fnode_::text,tnode_::text,lpoly_::text,rpoly_::text,length::text,xyc00002_::text,xyc00002_i::text,id::text,f_code::text,f_code_des::text,acc::text,acc_descri::text,exs::text,exs_descri::text,med::text,med_descri::text,rst::text,rst_descri::text,rsu::text,rsu_descri::text,rtt::text,rtt_descri::text,soc::text,tile_id::text,edg_id::text,asbinary(force_collection(force_2d(the_geom)),'NDR') from roads WHERE OID = 35115 in /home/www2/mapserv/sde_demo/functions.inc on line 105
> 
>