I have 3d lines in PostGIS database (representing hiking trails). I'm using phpPgAdmin administration tool. I want to use Dijkstra method for finding shortest way. I inserted all needed columns to execute this function, for example:
SELECT * FROM shortest_path(' SELECT gid AS id, start_id::int4 AS source, end_id::int4 AS target, cost_length::float8 AS cost FROM network', 1, 135, false, false)
I have .html file and .map file. I alredy have some functions and layers installed in my web application (like layer for shaded relief map). Also, I already have defined layer for 3d hiking trails from PostGIS database and it is shown on the web map by checkbox.
I never worked with pgRouting and MapServer before and I need help how to implement this function in my web application. I need detailed answer on how to implement it in my .map file and .html file. I need to enable users to choose one starting node (I will name them, but I don't know if I need to name it all?) from the combobox I want to define in my .html file, and one end node, also from the combobox, and then enable showing shortest path, or maybe list of nodes where they need to go for shortest path from start point to end point.
Don't give me links like : http://users.qgis.org/planet/user/4/tag/pgrouting/ because it doesn't give me an explanation about working with MapServer and pgRouting.
This is error when I'm trying to open my application:
writeLog(): Unable to access file. mslog.log msDrawMap(): Image handling error. Failed to draw layer named 'routing'. msPostGISLayerWhichShapes(): Query error. Error (ERROR: syntax error at or near "SELECT" LINE 1: ...) as geom,"gid" from (SELECT * FROM shortest_path(SELECT the... ^ ) executing query: select encode(ST_AsBinary(ST_Force_2D("the_geom"),'NDR'),'hex') as geom,"gid" from (SELECT * FROM shortest_path(SELECT the_geom as the_geom, gid AS id, %start_id%::int4 AS source, %end_id%::int4 AS target, cost_length::float8 AS cost FROM network, 1, 135, false, false)) AS foo where the_geom && GeomFromText('POLYGON((561819.89148581 5072537.66277129,561819.89148581 5093307.66277129,589524.782971619 5093307.66277129,589524.782971619 5072537.66277129,561819.89148581 5072537.66277129))',4326)