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

[Michele De Santis]

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



   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20130710/6cfd73ec/attachment.html>