- Original Message -
From: "Pablo Fischer" <[EMAIL PROTECTED]>
To: "Perl Beginners" <[EMAIL PROTECTED]>
Sent: Saturday, September 20, 2003 2:34 PM
Subject: Single and Double quotes in SQL
> Hi!
>
> I need to save some HTML text in a D
- Original Message -
From: "Pablo Fischer" <[EMAIL PROTECTED]>
To: "Perl Beginners" <[EMAIL PROTECTED]>
Sent: Saturday, September 20, 2003 2:34 PM
Subject: Single and Double quotes in SQL
> Hi!
>
> I need to save some HTML text in a D
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
nightma
On Sat, 20 Sep 2003 21:34:58 +, 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:
> It's so funny
$html_text =~ s/'/''/g;
$html_text =~ s/"/""/g;
Use the
Hi!
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:
It's so funny
Thanks!
Pablo
--
Pablo Fischer Sandoval (pablo -arroba- pablo.com.mx)
http://www.pablo.com.mx
http://www.debianmex
