It sounds like you are not using placeholders in your SQL. See: http://www.stupidfool.org/perl/docs/perltut/dbi/dbiplace.html for more information...
Using placeholders will take care of the correct escaping of characters automatically, and also will save you program becoming a security nightmare :-) (especially seeing that your data is going to be tainted) On Fri, 2003-09-19 at 12:41, Oliver Schnarchendorf wrote: > On Sat, 20 Sep 2003 21:34:58 +0000, Pablo Fischer wrote: > > I need to save some HTML text in a DataBase (MySql, using DBI). However > > some HTML text will have single and double quotes, so.. how can I save > > them?, for example: > > <align="center">It's so funny</align> > $html_text =~ s/'/''/g; > $html_text =~ s/"/""/g; > > Use the help of regular expressions to double the number of each quote and mysql > won't have any problems. > > thanks > /oliver/ -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
