AW: [mapserver-users] query in postgis works but in mapfile failed, why??
Eichner, Andreas - SID-NLKM
Andreas.Eichner at sid.sachsen.de
Thu Oct 20 03:28:23 PDT 2011
> 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".
More information about the MapServer-users
mailing list