AW: [mapserver-users] query in postgis works but in mapfile failed,why??

[Gery .]

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.Eichner at sid.sachsen.de
> To: gamejihou at hotmail.com; mapserver-users at 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".
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20111020/1e8fc6b8/attachment.htm>