[mapserver-users] dynamic sql to mapserver

[Michele De Santis]

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.

Thanks to all
Michele De Santis
 



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