[Cartoweb-users] [cartoweb]Query in mapfile

[Fabio D'Ovidio]

Hi!
I think subqueries have some problem from the mapfile...
You can try using FILTER tag in which you must specified the WHERE condition

Bye!

-- 
Ing. Fabio D'Ovidio

INOVA Open Solutions s.r.l.
Web : http://www.inovaos.it
Tel.: 081 197 57 600
mail: fabiodovidio at gmail.com


nadia ajala ha scritto:
> 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
>