[mapserver-users] Sql-Filter via URL

[Mehmet Sirin]

Hi,

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?



regards
m.sirin


    LAYER
        SYMBOLSCALE 50000
        NAME         'street'    # Layer-Name, der in OpenLayers aufgerufen
wird
        TYPE         LINE
        STATUS       DEFAULT

        CONNECTIONTYPE postgis    # Verbindung zur PostGIS-Datenbank
        CONNECTION "user=xxx password=xxx dbname=routing host=localhost
port=5432"
        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"

        CLASSITEM    'gid'
        DUMP TRUE
        CLASS
            STYLE
                SYMBOL 'circle'
                SIZE 9
                MINSIZE 9
                MAXSIZE 15
                COLOR 0 0 200
            END
        END
    END
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100123/3f9e9163/attachment-0001.html