[mapserver-users] Sql-Filter via URL
m.sirin07 at googlemail.com
Sat Jan 23 07:53:46 EST 2010
I would like to make some user specific sql-queries via url.
The Data line in the mapfile looks like:
DATA "geom from (select st_setsrid(the_geom,900913) as geom, gid from ways
where gid in (3137, 3138, 3139) ) as a using unique gid using srid=900913"
"gid" are parts of a street. These parts are chosen by the user in the
html-website. After that the sql-query have to be changed in mapfile. But
how to do that?
NAME 'street' # Layer-Name, der in OpenLayers aufgerufen
CONNECTIONTYPE postgis # Verbindung zur PostGIS-Datenbank
CONNECTION "user=xxx password=xxx dbname=routing host=localhost
DATA "geom from (select st_setsrid(the_geom,900913) as geom, gid
from ways where gid in (3137, 3138, 3139) ) as a using unique gid using
COLOR 0 0 200
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the mapserver-users