[mapserver-users] dynamic sql to mapserver

[Daniel Morissette]

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