[mapserver-users] Escape caracter on Mapfile

[Carlos Ruiz]

Cristiano,

Lo que dice la documentación ad literam es: If this is a PostGIS layer, the parameter should be in the form of
“<columnname> from <tablename>”, 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 <sumariva at gmail.com>
To: mapserver-users at 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



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100608/1d530e58/attachment.htm>