the code below is a layer in map file in this code i want create a query in postgis for shortestpath but a the number 77 and 388 is the source and target and the result create successfully but my problem is how insert the number ( 77, 388) in template file or insert by user how insert from html file
LAYER CONNECTION "host=localhost dbname=network user=postgres password=021555 port=5432" CONNECTIONTYPE POSTGIS DATA "geom from (SELECT * from pgr_dijkstra( 'SELECT gid as id , source , target , cost FROM tehran' , 77, 388, false , false ) a LEFT JOIN tehran b ON (a.id2 = b.gid)) AS foo using unique gid using srid=4326" NAME "shortestpath" PROJECTION "proj=utm" "zone=39" "datum=WGS84" "units=m" "no_defs" END # PROJECTION STATUS ON TEMPLATE "query" TILEITEM "location" TYPE LINE UNITS METERS CLASS NAME "Class (0)" STYLE COLOR 255 128 64 SIZE 8 WIDTH 10 END # STYLE END # CLASS END # LAYER
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users