hi,<br><br>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:<br><br><pre>class: SoapFaultWrapper<br>message: 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]<br>Backtrace:<br><br>file: 69 - /www/cartoweb3/projects/carene/plugins/demoRouting/server/ServerDemoRouting.php<br>call: Utils::checkDbError(Object(DB_Error), "Error quering routing database")</pre>here's the mapfile layer:<br>LAYER<br> NAME "graph"<br> TYPE LINE<br> STATUS ON<br> CONNECTIONTYPE postgis<br>
CONNECTION "user=my_user password=my_passwd host=localhost dbname=my_db"<br> DATA "the_geom from routing_results"<br> TEMPLATE "ttt"<br> END<br> 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.<br><br>can you tell me where this problem comes from?<br><br>thanks<p> 
<hr size="1">
Ne gardez plus qu'une seule adresse mail ! <a href="http://www.trueswitch.com/yahoo-fr/">Copiez vos mails</a> vers Yahoo! Mail