[Cartoweb-users] [cartoweb]Query in mapfile

[Fabio D'Ovidio]

nadia ajala ha scritto:
> Thanks,  but can you explain more?

    CONNECTIONTYPE POSTGIS
    DATA "the_geom from (SELECT servizi_geoc.gid, 
servizi_geoc.cognome_nome, servizi_geoc.indirizzo, 
servizi_geoc.tipo,servizi_geoc.via,servizi_geoc.civico,servizi_geoc.cap,servizi_geoc.comune,servizi_geoc.prov, 
servizi_geoc.telefono, servizi_geoc.happy_italy, 
servizi_geoc.happy_city, servizi_geoc.happy_nolimit, 
servizi_geoc.tutto_incluso, servizi_geoc.absolute_adsl, 
servizi_geoc.absolute_adsl_20_mega, servizi_geoc.tutto_incluso_20_mega, 
servizi_geoc.happy_italy_dist, servizi_geoc.happy_city_dist, 
servizi_geoc.happy_nolimit_dist, servizi_geoc.tutto_incluso_dist, 
servizi_geoc.absolute_adsl_dist, 
servizi_geoc.absolute_adsl_20_mega_dist, 
servizi_geoc.tutto_incluso_20_mega_dist, geoc.the_geom FROM 
servizi_geoc, geoc WHERE servizi_geoc.gid = geoc.gid) as foo using 
unique gid using SRID=4326"
      FILTER "happy_italy = 'Y' and comune ilike 'milano' "


>
>
> 2008/5/21 Fabio D'Ovidio <fabiodovidio at gmail.com 
> <mailto:fabiodovidio at gmail.com>>:
>
>     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 <mailto: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
>         <mailto:Cartoweb-users at lists.maptools.org>
>         http://lists.maptools.org/mailman/listinfo/cartoweb-users
>          
>
>
>

-- 
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