[mapserver-users] PostGIS syntax error

2009-10-30 Thread Ted Spradley
Hi All, Happy Halloween Scenario: I doing a 'mode=query' of a layer that takes the result of the query in the layer template and sends a subsequent 'mode=nquery' request to a different layer in the mapfile. The 'nqueried' layer template then does a

Re: [mapserver-users] PostGIS syntax error

2009-10-30 Thread Paul Ramsey
The format of DATA is 'geocolumn from geosource', so your DATA should be DATA wkb_geometry from (SELECT DISTINCT not DATA wkb_geometry,county,state from (SELECT DISTINCT don't worry, the SQL driver will add calls for those other columns when they are needed. You just need to make

Re: [mapserver-users] PostGIS syntax error

2009-10-30 Thread Ted Spradley
Many thanks Paul! - Original Message - From: Paul Ramsey [via OSGeo.org] To: Ted Spradley Sent: Friday, October 30, 2009 3:44 PM Subject: Re: [mapserver-users] PostGIS syntax error The format of DATA is 'geocolumn from geosource', so your DATA should be DATA