Laura is the definition of your DATA tag for the PG layer in the map file everything in a single line? If not, try to put it into a single line, it should work then. Otherwise let me know.
armin On 11/11/2011 19:03, Laura Larghero wrote: > > Hello, I'm working on MapServer 5.6, pmapper4.1 > Everything's fine, except those searches where I use joins, like this one > > Any help, please? > Thanks a lot!! > Laura > > -------------------------------------------------------------------------------------------------------------------------------------------- > mapfile definition > -------------------------------------------------------------------------------------------------------------------------------------------- > DATA "the_geom from (select nc.nombre_abreviado, > rc.id, rc.the_geom, rc.id_nomen_calle_ruta, rc.fuente, rc.tipo > from rutas_caminos rc > inner join nomen_nombre_calles_rutas nc on > rc.id_nomen_calle_ruta=nc.id) AS subquery > using unique id using srid=32721" > > -------------------------------------------------------------------------------------------------------------------------------------------- > pm_debug.log > -------------------------------------------------------------------------------------------------------------------------------------------- > P.MAPPER: PG Query error for : SELECT , > xmin(box3d(the_geom)), > ymin(box3d(the_geom)), > xmax(box3d(the_geom)), > ymax(box3d(the_geom)), > id_nomen_calle_ruta,nombre_abreviado,fuente,tipo > FROM (select nc.nombre_abreviado as nom_calle, > rc.id, rc.the_geom, rc.id_nomen_calle_ruta, rc.fuente, rc.tipo > from rutas_caminos rc > inner join nomen_nombre_calles_rutas nc on > rc.id_nomen_calle_ruta=nc.id) AS subquery > using unique id using srid=32721 as foo > WHERE nombre_abreviado ILIKE '%RUTA%' > LIMIT 301 > [11-Nov-2011 18:53:25] PHP Warning: pg_numrows() expects parameter 1 to be > resource, boolean given in /var/www/pmapper/incphp/query/squery.php on line > 711 > > ------------------------------------------------------------------------------ > RSA(R) Conference 2012 > Save $700 by Nov 18 > Register now > http://p.sf.net/sfu/rsa-sfdev2dev1 > _______________________________________________ > pmapper-users mailing list > pmapper-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/pmapper-users > ------------------------------------------------------------------------------ RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
