Escape double quotes in mapfiles/mapscript?

[Tamas Szekeres]

And we have also

http://mapserver.gis.umn.edu/bugs/show_bug.cgi?id=1549
http://mapserver.gis.umn.edu/bugs/show_bug.cgi?id=1622

Tamas


-----Original Message-----
From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On
Behalf Of Mike Leahy
Sent: Friday, May 12, 2006 11:07 PM
To: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: [UMN_MAPSERVER-USERS] Escape double quotes in mapfiles/mapscript?

Hello list,

I'm wondering if there is currently any way to escape double quotes in 
mapfile properties.  As an example, I want to be able to use a query on 
a PostGIS table as the data source for a layer, where columns' aliases 
have double quotes around them, as is normally done in PostgreSQL when 
spaces or other characters are involved (e.g., the following would crash 
MapServer 4.8:

DATA "the_geom from (select id as \"Field ID\", the_geom from sometable) 
as foo using unique \"Field ID\" using srid 5326;"

I also tried using two double quotes, but that didn't work either.  I 
noticed some discussion in a bug report related to this from a while 
back (http://mapserver.gis.umn.edu/bugs/show_bug.cgi?id=681), but as far 
as I can tell, it hasn't been addressed.  I can come up with my own 
workarounds for the problems, but I'd rather be sure whether or not this 
is possible first...

Thanks in advance for any advice,
Mike

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.5.6/337 - Release Date: 2006.05.11.
 

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.5.6/338 - Release Date: 2006.05.12.