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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > 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" > > > > >