<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'><div dir='ltr'>
<br>Thanks Andreas! your suggestion did the trick, thanks!<br><br>Cheers,<br><br>Gery <br><br><div>> Subject: AW: [mapserver-users] query in postgis works but in mapfile failed,why??<br>> Date: Thu, 20 Oct 2011 12:28:23 +0200<br>> From: Andreas.Eichner@sid.sachsen.de<br>> To: gamejihou@hotmail.com; mapserver-users@lists.osgeo.org<br>> <br>> > and the same in my mapfile gives nothing:<br>> > <br>> > DATA 'geom FROM (SELECT<br>> > seismic_line.fid,seismic_line.profile,seismic_line.geom FROM <br>> > seismic_line,<br>> > sar_contour_line WHERE seismic_line.geom && sar_contour_line.geom AND<br>> > INTERSECTS(seismic_line.geom, sar_contour_line.geom) AND<br>> > sar_contour_line.contour = -600) AS FOO USING UNIQUE fid USING UNIQUE<br>> > SRID=4326'<br>> > <br>> > why??<br>> <br>> Should probably be "...) AS FOO USING UNIQUE fid USING SRID=4326'" -<br>> without the "UNIQUE" in front of "SRID".<br></div> </div></body>
</html>