Hi
SELECT Object id #336 doesnt look like correct sql.
I would say some error occured when the sql was generated.
the $resultsId variable doesnt seem to be replaced correctly.
try to add:
x($resultsId);
at the beginning of the the getNodes function in ServerDemoRouting.php
this will display the content of the variable and stop further execution of the
program.
Let me know whats the result
regards
Oliver
----- Original Message -----
From: guillaume champlong
To: carto web
Sent: Sunday, June 24, 2007 7:18 PM
Subject: [Cartoweb-users] routing module
hi,
I have a problem with my routing module; everything works on pgsql
(functions, etc) but when I launch a research in my cartoclient, I have this
error:
class: SoapFaultWrappermessage: Error quering routing database Message: DB
Error: unknown error Userinfo: INSERT INTO routing_results SELECT Object id
#336, 1182704023, gid, the_geom FROM route500_44 WHERE edge_id = 533
[nativecode=ERREUR: erreur de syntaxe sur ou pr?s de ?id? at character
43]Backtrace:file: 69 -
/www/cartoweb3/projects/carene/plugins/demoRouting/server/ServerDemoRouting.phpcall:
Utils::checkDbError(Object(DB_Error), "Error quering routing database")here's
the mapfile layer:
LAYER
NAME "graph"
TYPE LINE
STATUS ON
CONNECTIONTYPE postgis
CONNECTION "user=my_user password=my_passwd host=localhost
dbname=my_db"
DATA "the_geom from routing_results"
TEMPLATE "ttt"
END
I specified the name of the column containing the name of the towns in the
routing.ini (client side), as well as the name of the vertices table.
can you tell me where this problem comes from?
thanks
------------------------------------------------------------------------------
Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail
------------------------------------------------------------------------------
_______________________________________________
Cartoweb-users mailing list
Cartoweb-users@lists.maptools.org
http://lists.maptools.org/mailman/listinfo/cartoweb-users
_______________________________________________
Cartoweb-users mailing list
Cartoweb-users@lists.maptools.org
http://lists.maptools.org/mailman/listinfo/cartoweb-users
