[Cartoweb-users] routing module

[Oliver Christen]

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 at lists.maptools.org
  http://lists.maptools.org/mailman/listinfo/cartoweb-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/cartoweb-users/attachments/20070625/f4649950/attachment.html