FILTER for value with apostrophe

sp sandrapaddock at GMAIL.COM
Thu Mar 3 14:37:05 EST 2005


Hi, all.

I'm having some problems constructing a query in my map file.  I'm
trying to do something pretty basic - grab some records based on a
field value - but I have an apostrophe in my target string, and I
think that's causing a problem.  All my other codes work just fine,
and this particular layer draws successfully if I substitute a
different species (e.g. one w/o an apostrophe).

This is the idea I'm trying to get at:
 FILTER  "Oriole (1st Bullock's)"

So, my questions are:
1) I searched and found limited references to known issues with string
encoding.  Is this related, or am I encountering some other issue?
2) Is there currently any way I can escape the apostrophe?
3) I've tried to create a regular expression, but I might be doing it
wrong.  Can I use a regex to get around this issue?  If so, any
suggestions on what that expression would look like, as my guess isn't
working  - "Oriole.(1st.Bullock.s)"

Please help - this is my first MapServer task in a VERY long time!

Thanks,
Sandra



More information about the mapserver-users mailing list