[thelist] Re: Adjusting strings for SQL

Jerry Scannell JerryScannell at cox.net
Mon Jul 14 20:29:05 CDT 2003

This may sound like a "kluge", but what I do is change the apostrophes to `
(I call it the backwards apostrophe since I don't know it's proper name.  It
is found next to the 1 key.

I, too, have always struggled with the double quote as a string delimiter,
and an apostrophe as an allowable alternative.  What do you do when the
apostrophe is part of the data.  My kluge takes care of it and nobody ever
really notices.  For instance, O'Neil and O`Neil look almost identical.

Try it.

----- Original Message -----
From: "Casey Crookston" <casey at thecrookstons.com>
To: <thelist at lists.evolt.org>
Sent: Monday, July 14, 2003 7:40 PM
Subject: Re: [thelist] Re: Adjusting strings for SQL

> I now have the same problem but in reverse:  A record in the db contains
> data "Gold's Gym."  When I load this record into a recordset and display
> it shows as "Gold".
> At what point do I work with the appastrophe to keep it from dropping?
> Thanks,
> Casey
> --
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> Evolt.org conference in London, July 25-27 2003.  Register today at
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !

More information about the thelist mailing list