[mapserver-users] query in mapfile

[thomas bonfort]

http://mapserver.org/cgi/runsub.html

On 18 June 2015 at 15:23, hosain mohammadi <hosain.moh00 at gmail.com> wrote:
> 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users