Escape double quotes in mapfiles/mapscript?

Mike Leahy mgleahy at GOLDEN.NET
Fri May 12 17:06:52 EDT 2006


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



More information about the mapserver-users mailing list