[thelist] Re: Adjusting strings for SQL

Anthony Baratta Anthony at Baratta.com
Mon Jul 14 18:56:55 CDT 2003

At 04:40 PM 7/14/2003, Casey Crookston wrote:
>I now have the same problem but in reverse:  A record in the db contains the
>data "Gold's Gym."  When I load this record into a recordset and display it,
>it shows as "Gold".
>At what point do I work with the appastrophe to keep it from dropping?


Going into the Database, you need to escape the '. (Use the function I sent 
you earlier.) Coming out of the database, you should use HTMLEncode to 
convert all problematic characters that could interfere with your HTML. 
(Use the function I sent you today.)

Anthony Baratta
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."

More information about the thelist mailing list