FILTER for value with apostrophe

[Jeff Portwine]

Can't you do something like:
"Oriole (1st Bullock\'s)"

to make it work with the apostrophe?

-Jeff


----- Original Message -----
From: "sp" <sandrapaddock at GMAIL.COM>
To: <MAPSERVER-USERS at LISTS.UMN.EDU>
Sent: Thursday, March 03, 2005 2:37 PM
Subject: [UMN_MAPSERVER-USERS] FILTER for value with apostrophe


> 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  >
> 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
>