[mapserver-users] queryByPoint + PostGIS layers + USING statement

2008-07-21 Thread Stefan Schwarzer
Hi there, it seems that it's mandatory for postgis layers to use the USING statement in the query. My layer parameters look a bit like this: DATA 'the_geom FROM ( SELECT FROM xxx LEFT JOIN WHERE xxx) AS foo USING UNIQUE uid USING srid=4326) ' But nevertheless, mapserver

Re: [mapserver-users] queryByPoint + PostGIS layers + USING statement

2008-07-21 Thread Kristian Thy
On Mon, Jul 21, Stefan Schwarzer wrote: My layer parameters look a bit like this: DATA 'the_geom FROM ( SELECT FROM xxx LEFT JOIN WHERE xxx) AS foo USING UNIQUE uid USING srid=4326) ' You have an extra ) at the end. But nevertheless, mapserver doesn't like it... If

Re: [mapserver-users] queryByPoint + PostGIS layers + USING statement

2008-07-21 Thread Carlos Ruiz
sets to -1. If you're an expert user, you can alter the values of the geometry_columns table. IC Carlos RuizĀ  --- On Mon, 7/21/08, Stefan Schwarzer [EMAIL PROTECTED] wrote: From: Stefan Schwarzer [EMAIL PROTECTED] Subject: [mapserver-users] queryByPoint + PostGIS layers + USING statement