[Cartoweb-users] routing module

[guillaume champlong]

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:   SoapFaultWrapper
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]
Backtrace:

file: 69 - /www/cartoweb3/projects/carene/plugins/demoRouting/server/ServerDemoRouting.php
call: 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 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/cartoweb-users/attachments/20070624/b331ac61/attachment.html