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 -- Edu ------------------------------------------------------------------------------ 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
