query postgis through wms

[Steven De Vriendt]

I will reconvert my data again in PostGIS.
I think ogr2or creates a oid automatically.
Thanks for helping out

Steven

On Nov 19, 2007 4:01 PM, Marcos Sánchez Provencio <marcos at burke.ath.cx>
wrote:

> Try setting debug and see what querys get the database.
>
>
> El lun, 19-11-2007 a las 15:31 +0100, Steven De Vriendt escribió:
> > 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/059f3d41/attachment.html