query postgis through wms

[Marcos Sánchez Provencio]

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"
>                 
>                 
>         
>         
>