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: dmorisse...@mapgears.com Data: 10-lug-2013 14.09 A: <mapserver-users@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
-- Daniel Morissette http://www.mapgears.com/ Provider of Professional MapServer Support since 2000 _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users