[mapserver-users] Escape caracter on Mapfile

Cristiano Sumariva sumariva at gmail.com
Tue Jun 8 15:24:35 EDT 2010


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/804e16b5/attachment.html


More information about the mapserver-users mailing list