[Cartoweb-users] [cartoweb]Query in mapfile

[nadia ajala]

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