if you need it dynamically adapted to a search value you either have to
modify via Mapscript the DATA tag with the complete SQL (adapting the
one below), or modify the FILTER tag with the WHERE part of the SQL.
armin
Gabe wrote:
Where would we put this sql ?
in the mapfile layer object ?
Where would we put this sql ?
in the mapfile layer object ?
or as a view in postgis ?
G
On 10/27/06, Gail Long [EMAIL PROTECTED] wrote:
For post gis layers:
select streetnameField,
oid, xmin(box3d(p.the_geom)) AS minx, ymin(box3d(p.the_geom)) AS miny,
xmax(box3d(p.the_geom)) AS maxx,
It's not a question related to pmapper because it doesn't do it.
My suggestion is to import shape into postgis and prepare a query for
searching intersections. You can easily do there such.
So the right pace to ask is postgis or mapserver ML.
luca
On 10/26/06, Cristian Rougier [EMAIL PROTECTED]