query postgis through wms

[Steven De Vriendt]

update:
when I use SRID=-1 I get a map in return but I'm still unable to query it..

Steven

On Nov 19, 2007 3:26 PM, Steven De Vriendt <gisaalter at gmail.com> wrote:

> Marcos,
>
> When I try your suggestion Mapserver returns:
>
> −
>     <ServiceExceptionReport version="1.1.0">
> −
>     <ServiceException>
>
> msDrawMap(): Image handling error. Failed to draw layer named 'percelen'.
> msPOSTGISLayerWhichShapes(): Query error. Error executing POSTGIS SQL
> statement (in FETCH ALL): DECLARE mycursor BINARY CURSOR FOR SELECT
> asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from (SELECT
> * FROM b_capa_percid) AS foo WHERE the_geom && setSRID('BOX3D(
> 76945.5918856108 189996.502536997,91328.1081143621 201805.497460877)'::BOX3D,
> 31300 )
> -ERROR:  Operation on two geometries with different SRIDs
>
>
> </ServiceException>
> </ServiceExceptionReport>
>
>
> On Nov 19, 2007 3:19 PM, Marcos Sánchez Provencio <marcos at burke.ath.cx>
> wrote:
>
> > try
> > DATA "the_geom from (SELECT * FROM b_capa_percid) as foo
> > using srid=31300 using unique gid"
> >
> >
> >
> > El lun, 19-11-2007 a las 09:48 +0100, Steven De Vriendt escribió:
> > > DATA "the_geom from b_capa_percid"
> >
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20071119/fb4ed0da/attachment.htm>