Puede ser que el problema sea la columna DESCRIPTOR, ya que si está en mayúscula, en PSQL le debes poner comillas.
Prueba lo que dice Francisco.. saludos Cristian O. www.digitalbee.cl On Tue, May 24, 2011 at 10:50 AM, francisco.goma...@gmail.com < francisco.goma...@gmail.com> wrote: > Yo haría para tus datos lo siguiente: > > DATA 'the_geom from (SELECT * FROM zonas_salud WHERE > DESCRIPTOR='Terciaria') AS subquery USING UNIQUE gid USING srid=23030' > > si lo que quieres es seleccionar las entidades que tengan exactamente > esa palabra, sino sería LIKE '%Terciaria%' con comodines (también suelo > definir el srid) > > Un saludo > > El 24/05/2011 15:56, Eduardo Bieñkowski escribió: > > Tengo una consuita para realizar respecto de una SQL en la que quiero > > recuperar datos según un campo de texto. > > He utilizado LIKE no funciona > > DATA 'the_geom from (SELECT * FROM zonas_salud WHERE "DESCRIPTOR" LIKE > > 'Terciaria') AS zonas USING UNIQUE gid' > > asi tampoco > > DATA 'the_geom from (SELECT * FROM zonas_salud WHERE "DESCRIPTOR" LIKE > > "Terciaria") AS zonas USING UNIQUE gid' > > > > He utilizado el signo de = con comillas simples no funciona, > > DATA 'the_geom from (SELECT * FROM zonas_salud WHERE "DESCRIPTOR" > > ='Terciaria') AS zonas USING UNIQUE gid' > > > > He utilizado el signo de = con comillas dobles tampoco > > DATA 'the_geom from (SELECT * FROM zonas_salud WHERE "DESCRIPTOR" > > ='"Terciaria") AS zonas USING UNIQUE gid' > > > > Sin nada tampoco funciona > > DATA 'the_geom from (SELECT * FROM zonas_salud WHERE "DESCRIPTOR" LIKE > Ruta > > Terciaria) AS zonas USING UNIQUE gid' > > DATA 'the_geom from (SELECT * FROM zonas_salud WHERE "DESCRIPTOR" > > =Terciaria) AS zonas USING UNIQUE gid' > > > > Los errores que me salen son del tipo: > > [24-May-2011 10:54:19] PHP Warning: [MapServer Error]: msDrawMap(): > Failed > > to draw layer named 'zonas_salud'. > > in /var/www/pmapper-4.0/incphp/globals.php on line 60 > > [24-May-2011 10:54:19] PHP Warning: [MapServer Error]: > > msPostGISLayerWhichShapes(): Error (ERROR: error de sintaxis en o cerca > de > > «Terciaria» > > LINE 1: ...ROM zonas_salud WHERE "DESCRIPTOR" = Terciaria)... > > > > > > > > > > Sin embargo si lo hago con PSQL pasando el SELECT * FROM zonas_salud > WHERE > > "DESCRIPTOR" ='Terciaria' > > ESTO SI FUNCIONA > > > > > > ------------------------------------------------------------------------------ > vRanger cuts backup time in half-while increasing security. > With the market-leading solution for virtual backup and recovery, > you get blazing-fast, flexible, and affordable data protection. > Download your free trial now. > http://p.sf.net/sfu/quest-d2dcopy1 > _______________________________________________ > pmapper-users mailing list > pmapper-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/pmapper-users > ------------------------------------------------------------------------------ vRanger cuts backup time in half-while increasing security. With the market-leading solution for virtual backup and recovery, you get blazing-fast, flexible, and affordable data protection. Download your free trial now. http://p.sf.net/sfu/quest-d2dcopy1 _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
