[mapserver-users] R: Re: dynamic sql to mapserver

[Daniel Morissette]

Run-time substitutions work with both traditional CGI and WMS requests.

The key is to make sure you have the VALIDATION patterns set properly.

Daniel


On 13-07-10 9:20 AM, Michele De Santis wrote:
> Thanks,
>
> but does it work only with a standard cgi request? Does it means that i
> can't do runtime substitution with a WMS request?
>
> michele
>
> ----Messaggio originale----
> Da: dmorissette at mapgears.com
> Data: 10-lug-2013 14.09
> A: <mapserver-users at lists.osgeo.org>
> Ogg: Re: [mapserver-users] dynamic sql to mapserver
>
> On 13-07-10 5:25 AM, Michele De Santis wrote:
>  > Hi to everyone,
>  >
>  > in my webgis application I'm using OpenLayers to request WMS layers to
>  > MapServer 6.2.1. Is it possible to send dynamic sql to mapserver using
>  > function of PostGIS (for example ST_Distance)?
>  >
>  > /select * from table
> where//st_distance(the_geom,GeomFromText('Point(1 0)',4326)) <6) as myquery;
>  >
>  > /What I would like to be able to do is pass user defined variables
> e.g. latitude, longitude and distance.
>  >
>
>
> %variable% run-time substitution should do what you need, see:
>
> http://mapserver.org/cgi/runsub.html
>
>
> --
> Daniel Morissette
> http://www.mapgears.com/
> Provider of Professional MapServer Support since 2000
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
>
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>


-- 
Daniel Morissette
http://www.mapgears.com/
Provider of Professional MapServer Support since 2000