Use the $dbh->quote function, it is part of the DBI interface...
$foo = $dbh->quote($foo);
Brent
james lundeen
<jameslundeen@yah To: "'[EMAIL PROTECTED]'"
<[EMAIL PROTECTED]>
oo.com> cc: (bcc: Brent
Michalski/STL/MASTERCARD)
Subject: really basic question about
CGI module
12/12/02 02:42 PM
I "use CGI" in my routines very often and at times need to look at the
incoming values from forms
to make sure that they don't include "'" "," and other things that might
blow up my connection
with mysql database. Can someone please give me a nice piece of reusable
code that will read the
incoming variable and clean up all of the charecters that the user might
have entered that certain
programming routines might not like? Specifically, I have run into
problems if the user has "
' , in the field. maybe there are others too? any help and code
would be appreciated!
-jimmyjames
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
