[Mapserver-west] escape double quotes for postgis

Ken-ichi Ueda kenichi.ueda at gmail.com
Fri Jul 29 12:01:02 EDT 2005


Hey Tyler.  I hadn't thought of that, but it works!  I guess it
doesn't address the problem directly, but it's a good work-around. 
Thanks!

-Ken-ichi

On 7/28/05, Tyler Mitchell <tylermitchell at shaw.ca> wrote:
> On July 28, 2005 05:54 pm, Ken-ichi wrote:
> > Hi folks.  Does anyone know how to escape double quotes in a mapfile?  I
> > have a PostGIS query I need to use that contains a lot of double-quoted
> > field names because several tables were ported from MySQL and a lot of
> > things are named with capitals.  This screws up the DATA line of my
> > LAYER definition.  I can't just enclose everything in single quotes
> > because I have plenty of single quote in my query as well.
> 
> Hi Ken-ichi,
> Are you able to create a view of the table that basically aliases the
> capitalised fields?
> 
> Tyler
>



More information about the Mapserver-west mailing list