[Cartoweb-users] [cartoweb]Query in mapfile

[Oliver Christen]

mmm, it seems it doesnt like you station."ident_station"
did you try without the " " ?
otherwise do as Fabio D'Ovidio suggested

regards
Oliver
  ----- Original Message ----- 
  From: nadia ajala 
  To: cartoweb-users at lists.maptools.org 
  Sent: Wednesday, May 21, 2008 9:49 AM
  Subject: [Cartoweb-users] [cartoweb]Query in mapfile


  Hello,
  I'm  trying, from  mapfile, view the result of query that interrogates two tables of a database postgresql one of which is spatial (station).

  Here is the code:

DATA "the_geom from (SELECT station.* FROM station, plj_datalog WHERE  station."ident_station"=Plj_datalog."IDENT_station" AND station."type"='HP' AND plj_datalog."DATE_MES"='2004-04-19')foo  using unique ident_station using srid=-1"
  This query returns a result under pgAdminIII while under cartoweb I have the following error:

Mapserver error: Error in getString(): Parsing error near (the_geom from (SELECT station.* FROM station, plj_datalog WHERE  station.):(line 279)
  Thanks for your help.



------------------------------------------------------------------------------


  _______________________________________________
  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/20080521/e62ee21f/attachment.html