[mapserver-users] dynamic sql mapserver

Hi all I am trying to figure out the way to create dynamic sql using mapserver (using the basic demo application under MS4W) and postgres/postgis. I have created various queries that work ok as follows: LAYER CONNECTIONTYPE postgis NAME "qdistance" CONNECTION "user="" password="" dbname="test"

[mapserver-users] Dynamic SQL

Hi All Many thanks to Pietro Giannini and David Fawcett for your help but I am still struggling with getting a dynamic sql statement to work. I have gone back to trying a simple sql statement in the layer definition which works fine like this: LAYER CONNECTIONTYPE postgis NAME "kbapoly" CONNEC

[mapserver-users] dynamic sql

Hi all Many thanks for your iputs to this. I have managed to get the simple query as follows working; DATA "the_geom from (select gid, intname, the_geom from kbapoly where intname = '%mquery%') As myquery using SRID=4326 using unique gid" It was a simple case of quoting the %mquery% (thought I h

[mapserver-users] dynamic sql

Hi all Finally managed to get everything working.. a case of deleting one of a repeated variable in the template file that was causing the problem! Many thanks for all your help, much appreciated! Mark ___ mapserver-users mailing list mapserver-users@l

[mapserver-users] Postgis query

Hi All I am trying to output a query from postgis using three tables and it is not quite working. First table is a quarter degree grid (spatial table) Second table is a table with each grid cell id along with many species id per grid cell Third table is list of species My query definition works

[mapserver-users] Postgis query

Hi All Many thanks to Paul with regards to enabling statement logging (extremely useful to help find out what sql is being sent) and thanks to Carlos for suggesting the joins.. this was the problem which I can happily say that I have resolved. What an amazing combination of software really, Mapser

[mapserver-users] passing coordinates to a postgis query

Hi all I am trying to pass latitude and longitude coordinates to a postgis query but I am getting confused. So far I have tried to use the following DATA definition as follows: DATA "the_geom FROM (select * from kbapoly where st_distance(the_geom,GeomFromText('Point(%mapy% %mapx%)',4326)) <6) AS

[mapserver-users] Adding a buffer symbol

Hi All Having worked out how to display a selection of features within a mouse click (passing the coordinates to postgis query) and colour coding these using classitem for specified distances away from a mouse click e.g. within 1 decimal degree, within 2 decimal degrees and within 3 decimal degree

[mapserver-users] Re: Adding a buffer symbol

Hi Venkat At the moment I am just using the CGI mapserver. I was wondering if this can be done or ben achieved using Labels and symbols? but if needs be then I guess either javascript or php would be used to do this. Many thanks Mark On Mon, Dec 8, 2008 at 11:02 AM, mark balman <[EM

[mapserver-users] Adding a wms layer

Hi all I amtrying to add a wms layer into my application but cannot seem to figure this out. I would like to use the OnEarth layer from NASA. Can anyone point me in the right direction? Many thanks Mark ___ mapserver-users mailing list mapserver-users@