<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial,helvetica,sans-serif;font-size:10pt">Cristiano,<br><br>Lo que dice la documentación ad literam es: <span style="font-style: italic;">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.</span><br><br>Por lo que creo que no es válido hacer uso de caracteres de escape.<br><br>Yo en lo personal, he tenido problemas con el escape de comillas dobles y simples dentro de las expresiones <br>en las etiquetas EXPRESSION, supongo que tal vez esto del escape no funcione de manera estática (desde <br>el archivo MAP) sino de manera dinámica (Haciendo uso de Mapscript).<br><br>Saludos desde México<br><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><br><span style="font-weight: bold; color: rgb(0, 96, 191);">IC Carlos Ruiz</span><br style="font-weight: bold; color: rgb(0, 96, 191);"><br style="font-weight: bold; color: rgb(0, 96, 191);"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><font face="Tahoma" size="2"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Cristiano Sumariva <sumariva@gmail.com><br><b><span
style="font-weight: bold;">To:</span></b> mapserver-users@lists.osgeo.org<br><b><span style="font-weight: bold;">Sent:</span></b> Tue, June 8, 2010 2:24:35 PM<br><b><span style="font-weight: bold;">Subject:</span></b> [mapserver-users] Escape caracter on Mapfile<br></font><br>
People I got on this situation: mixing single quotes with double quotes.<br>Mapserver say at following page :<br><span><a target="_blank" href="http://mapserver.org/mapfile/expressions.html">http://mapserver.org/mapfile/expressions.html</a></span><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>
</div></div>
</div><br>
</body></html>