Re: your mail

["Stephen C. Lorenz" <slorenz@SEAHAWK.NSCC.MASS.EDU>]

Sheri,

If you use the apostrophe symbol twice (i.e. O''Hara), sqr will interpret
this as O'Hara.  (The same applies with the exclamation mark (!!).

Hope this helps,
Steve

------------------------------------------------------------------------------
>  Stephen C. Lorenz -- Systems Analyst | North Shore Community College      <
>  slorenz@nscc.mass.edu                | 1 Ferncroft Rd, Danvers, MA 01923  <
------------------------------------------------------------------------------

On Tue, 16 Dec 1997, Sheri Coleman wrote:

> Hi
>
> I need some help and feel like I am overlooking a perfectly straight forward
> way to do this.
>
> My problem:  I need to allow my user to use a parameter to select names on
> which to select in this label report.  What do I do about names with
> apostrophes?  If my statement says  -- and spriden_last_name in ('Cohen',
> 'Jones', 'O'Hara' -- the program fails.  I need to get the name from the
> user and then build the where clause dynamically.
>
> We have functions (mini-SQRs) that we use to build these joins when using
> lists but because of the apostrophe that function won't work.
>
> I need make sure this takes into account the number of people in the list,
> using '=' or 'in'.
>
> Thanks for any ideas you may have.
>
> Sheri Coleman
> coleman@hudce.harvard.edu
>
>