Re: [MAPSERVER-USERS] [Postgis] Intersection on requested data

2008-10-31 Thread G. Tiemens
Paul Ramsey-3 wrote: > > You need to understand the syntax of the DATA statement, which is not > pure SQL. It is: > > [columntodraw] FROM [sourceofdata] USING UNIQUE [uniquekey] USING > SRID=[srid] > > columntodraw is always assumed to be a single word. > > Write your data statement like this

Re: [MAPSERVER-USERS] [Postgis] Intersection on requested data

2008-10-31 Thread Paul Ramsey
You need to understand the syntax of the DATA statement, which is not pure SQL. It is: [columntodraw] FROM [sourceofdata] USING UNIQUE [uniquekey] USING SRID=[srid] columntodraw is always assumed to be a single word. Write your data statement like this: DATA "the_geom FROM (SELECT gid,ST_Inter

RE: [MAPSERVER-USERS] [Postgis] Intersection on requested data

2008-10-30 Thread G. Tiemens
For some reason the copy paste didn't work, so here a repost of the error of Mapserver: http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd";> msDrawMap(): Image handling error. Failed to draw layer named 'KLLine'. prepare_database(): Query error. Error declaring cursor: ERROR: syntax e

RE: [MAPSERVER-USERS] [Postgis] Intersection on requested data

2008-10-29 Thread Tiemens, Gerben
To add to my previous post: This is the error given by MapServer: Greetings Gerben -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens G. Tiemens Verzonden: Wednesday, October 29, 2008 4:12 PM Aan: mapserver-users@lists.osgeo.org Onderwerp: [MAPSERVER-USER