Cristiano,
Lo que dice la documentación ad literam es: If this is a PostGIS layer, the
parameter should be in the form of
“ from ”, where “columnname” is the
name of the
column containing the geometry objects and “tablename” is the name of
the
table from which the geometry data will be read.
Por lo que creo que no es válido hacer uso de caracteres de escape.
Yo en lo personal, he tenido problemas con el escape de comillas dobles y
simples dentro de las expresiones
en las etiquetas EXPRESSION, supongo que tal vez esto del escape no funcione de
manera estática (desde
el archivo MAP) sino de manera dinámica (Haciendo uso de Mapscript).
Saludos desde México
IC Carlos Ruiz
From: Cristiano Sumariva
To: mapserver-users@lists.osgeo.org
Sent: Tue, June 8, 2010 2:24:35 PM
Subject: [mapserver-users] Escape caracter on Mapfile
People I got on this situation: mixing single quotes with double quotes.
Mapserver say at following page :
http://mapserver.org/mapfile/expressions.html
that for expressions it allow escape.
Do it allow escape on other mapfile attributes ?
Current mapserver version is 5.4.1
I need the following string layer data attribute to create an query to perform
a column concat since address is a compound information and has some null
values.
I know some will say fix your data.
It is stopping at CATEG: Parsing error near (CATEG)
data "the_geom from ( select oid, *, \"CATEG\"||( CASE WHEN \"PREP\" is null
THEN ' '::text ELSE \"PREP\" END )||\"LOGR\" as full_address from
street_main_dissolv_utm ) as street_main_address_with_length_over_ten_kilometer"
Postgresql lexer rules are:
Identifiers are quoted with double quotes.
A column name is an identifier.
And column name identifiers not quoted are lower cased.
So need the double quotes around those upper case identifiers.
Text strings are quoted in single quotes.
|| is string concat operator
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
