[Cartoweb-users] [cartoweb]Query in mapfile

Fabio D'Ovidio fabiodovidio at gmail.com
Wed May 21 03:59:27 EDT 2008

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


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

More information about the Cartoweb-users mailing list