[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?
Casey...
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
President
Keyboard Jockeys
"Conformity is the refuge of the unimaginative."
More information about the thelist
mailing list