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
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users
