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: andreas.eich...@sid.sachsen.de
> To: gameji...@hotmail.com; mapserver-users@lists.osgeo.org
>
> > 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
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
