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 written between simple quotes (nombre = 'HOSPITAL ARTIGAS'). So to simplify the DATA line you should write it between double quotes. Thomas Le 29/07/2011 20:17, Eduardo Bieñkowski a écrit : > 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 existe la columna «HOSPITAL > ARTIGAS» > LINE 1: ...lect * from "pais_equipoimagen_pt" WHERE nombre = "HOSPITAL ... > > Lo hago con comillas simples, tampoco funciona me pone esto > > DATA 'the_geom FROM (select * from "pais_hospitales" WHERE nombre = > 'HOSPITAL ARTIGAS') as hospital USING UNIQUE gid USING srid=32721' > > > [29-Jul-2011 15:12:45] PHP Warning: [MapServer Error]: loadLayer(): Parsing > error near (HOSPITAL):(line 483) > in /var/www/pmapper-4.0/incphp/globals.php on line 60 > > Controlo con psql que funcione y funciona (con comillas simples) > > geodb=> select * from pais_hospitales where nombre='HOSPITAL ARTIGAS'; > > gid | depto | seccion | localidad | nombre | ue | > calle | n_mero | esquina | telefono | xcoord | ycoord | > metropo | nom_dep | nom_loc | a_p | b_p | c_p | d_p | e_p | a_a | b_a | c_a > | d_a | e_a | a_t | b_t | c_t | d_t | e_t | a_c | b_c | c_c | d_c | e_c | > a_m | d_m | a_tom | b_tom | c_tom | d_tom | e_tom | a_reso | b_reso | c_reso > | d_reso | e_reso | a_d | the_geom > -----+-------+---------+-----------+------------------+----+-------------------+--------+------------------+----------+---------+---------+---------+---------+---------+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-------+-------+-------+-------+-------+--------+--------+--------+--------+--------+-----+---------------------------------------------------- > 40 | 2 | 1 | 220 | HOSPITAL ARTIGAS | 15 | EDUARDO M. > CASTRO | 0 | FRUCTUOSO RIVERA | 47723701 | 551974 | 6636455 | 0 | > ARTIGAS | Artigas | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | > 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 > | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 > | 0 | 1 | 0101000020D17F0000000000004CD82041000000C0E9505941 > (1 fila) > > (END) > > Supongo que debe ser algún caracter de control que no se cual es. > Escucho sugerencias > Saludos > > > > > > > > > > > > > > > > > > DATA 'the_geom FROM (select * from "pais_hospitales" WHERE nombre =' > HOSPITAL ARTIGAS') as hospital USING UNIQUE gid USING srid=32721' > > > > > > 2011/7/29 Victoria Alvarez<vickyalva...@gmail.com> > >> La consulta en el .map debería ser algo así: >> >> DATA 'the_geom FROM (select * from "pais_hospitales" WHERE nombre = >> "Hospital Artigas") as hospital USING UNIQUE gid USING srid=32721' >> >> En el que copiaste falta el primer from >> >> 2011/7/29 Eduardo Bieñkowski<eduko...@gmail.com> >> >>> En la base funciona, supongo que debe ser algún caracter de control, no lo >>> sé, porque si lo pruebo con campos númericos funciona >>> >>> DATA 'the_geom from (SELECT * FROM "pais_hospitales" WHERE ue= 15) AS >>> subquery USING UNIQUE gid USING srid=32721' >>> >>> Esto funciona. >>> Saludos >>> >>> >>> >>> 2011/7/29 Victoria Alvarez<vickyalva...@gmail.com> >>> >>>> Hola, >>>> ¿La consulta directo en la BD funciona? Eso sería lo primero a probar, >>>> para ver si es un tema de la sentencia SQL o de sintaxis en el .map >>>> No sé como están los datos en la tabla, pero que que los seleccione el = >>>> deben coincidir exactamente con lo que escribís. Sino deberías utilizar >>>> LIKE >>>> y manejarte con %. >>>> Saludos, >>>> Vitcoria >>>> >>>> >>>> 2011/7/29 Eduardo Bieñkowski<eduko...@gmail.com> >>>> >>>>> Estimada >>>>> Probe de estas dos maneras el poder ver solo un punto del conjunto de >>>>> hospitales >>>>> >>>>> DATA 'the_geom (select * FROM "pais_hospitales" WHERE nombre = "Hospital >>>>> Artigas") as subquery USING UNIQUE gid USING srid=32721' >>>>> DATA 'the_geom FROM "pais_hospitales" WHERE nombre = "Hospital Artigas" >>>>> USING UNIQUE gid USING srid=32721' >>>>> >>>>> Que estoy haciendo mal que no logro ver nada?? >>>>> >>>>> >>>>> -- >>>>> Eduardo >>>>> >>>> >>> >>> -- >>> Eduardo >>> >> > ------------------------------------------------------------------------------ Got Input? Slashdot Needs You. Take our quick survey online. Come on, we don't ask for help often. Plus, you'll get a chance to win $100 to spend on ThinkGeek. http://p.sf.net/sfu/slashdot-survey _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
