ok, it works fine. thanks for your help michele
----Messaggio originale---- Da: [email protected] Data: 10-lug-2013 15.22 A: <[email protected]> Ogg: Re: [mapserver-users] R: Re: dynamic sql to mapserver 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: [email protected] > Data: 10-lug-2013 14.09 > A: <[email protected]> > 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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > > > > _______________________________________________ > mapserver-users mailing list > [email protected] > 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 [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
