Thanks Andreas! your suggestion did the trick, thanks!
Cheers, Gery > Subject: AW: [mapserver-users] query in postgis works but in mapfile > failed,why?? > Date: Thu, 20 Oct 2011 12:28:23 +0200 > From: [email protected] > To: [email protected]; [email protected] > > > and the same in my mapfile gives nothing: > > > > DATA 'geom FROM (SELECT > > seismic_line.fid,seismic_line.profile,seismic_line.geom FROM > > seismic_line, > > sar_contour_line WHERE seismic_line.geom && sar_contour_line.geom AND > > INTERSECTS(seismic_line.geom, sar_contour_line.geom) AND > > sar_contour_line.contour = -600) AS FOO USING UNIQUE fid USING UNIQUE > > SRID=4326' > > > > why?? > > Should probably be "...) AS FOO USING UNIQUE fid USING SRID=4326'" - > without the "UNIQUE" in front of "SRID".
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
