Re: [pmapper-users] SQL pmapper

2011-08-02 Thread Sandro Ferrara
Hi Eduardo, try as Thomas wrote and also try to change into DB the column name HOSPITAL ARTIGAS (uppercase) in hospital artigas (lowercase) google translator: Hola Eduardo Por mucho que Thomas escribió y también tratar de cambiar en la base de datos de la columna nombre HOSPITAL ARTIGAS (en mayú

Re: [pmapper-users] SQL pmapper

2011-08-01 Thread Thomas RAFFIN
Hi, I don't understand your e-mail (I only understand English and French) but I think DATA should be written like this: DATA "the_geom FROM (select * from pais_hospitales WHERE nombre = 'HOSPITAL ARTIGAS') as hospital USING UNIQUE gid USING srid=32721" Indeed with postgreSQL, strings have to be

Re: [pmapper-users] SQL pmapper

2011-07-29 Thread Eduardo Bieñkowski
Lo hice como me enviaste. DATA 'the_geom FROM (select * from "pais_hospitales" WHERE nombre = "HOSPITAL ARTIGAS") as hospital USING UNIQUE gid USING srid=32721' y no funciona me envia esto [29-Jul-2011 15:10:25] PHP Warning: [MapServer Error]: msPostGISLayerWhichShapes(): Error (ERROR: no exis