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
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