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

2013-07-10 Thread Daniel Morissette

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: 
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


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

2013-07-10 Thread 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: dmorisse...@mapgears.com
Data: 10-lug-2013 14.09
A: 
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