Cleaning strings for use in SQL queries

Andreas Kaempf <[email protected]>
Newsgroups gmane.comp.web.skunkweb
Organization Soundience, Ltd.
Message-ID <[email protected]>
I am running into some problems with single quotes embedded within form
input strings causing exceptions when executing SQL queries (the
apostrophe is interpreted as the closing quote within the query). Before
writing a routine to clean strings of such stuff, I was wondering
whether there was already something in SkunkWeb to do this, or if there
was another source that anyone can recommend.

Thanks,
Andreas Kaempf


-------------------------------------------------------
This SF.Net email is sponsored by: thawte's Crypto Challenge Vl
Crack the code and win a Sony DCRHC40 MiniDV Digital Handycam
Camcorder. More prizes in the weekly Lunch Hour Challenge.
Sign up NOW http://ad.doubleclick.net/clk;10740251;10262165;m
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.