People I got on this situation: mixing single quotes with double quotes.<br>Mapserver say at following page :<br><a href="http://mapserver.org/mapfile/expressions.html">http://mapserver.org/mapfile/expressions.html</a><br>
that for expressions it allow escape.<br>Do it allow escape on other mapfile attributes ?<br><br>Current mapserver version is 5.4.1<br><br>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.<br>
I know some will say fix your data.<br><br>It is stopping at CATEG: Parsing error near (CATEG)<br><br>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"<br>
<br><br>Postgresql lexer rules are:<br> Identifiers are quoted with double quotes. <br> A column name is an identifier.<br> And column name identifiers not quoted are lower cased.<br> So need the double quotes around those upper case identifiers.<br>
<br> Text strings are quoted in single quotes.<br> || is string concat operator<br>