[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