[mapserver-users] query in mapfile

hosain mohammadi hosain.moh00 at gmail.com
Thu Jun 18 06:23:54 PDT 2015


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20150618/64dc63d0/attachment.htm>


More information about the MapServer-users mailing list