perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Hanisch <hani...@informatik.uni-muenchen.de>
Subject Re: error DBI with quote
Date Thu, 06 Jul 2000 13:05:42 GMT
On Thu, 6 Jul 2000, Jesús Lasso Sánchez wrote:

> Hi,
> 
>    I probed:
> 
>           s/'/''/g
> 
>    yesterday but it did'nt work, will try with HTML code. I think is the
> solution.
> 
> 
> Thanks
> 
> > the easiest way is
> > s/'/''/g
> > or
> > s/'/&#39;/g
> >
> 
> 

Hi,

AFAIK DBI's bind_param method should call DBI::quote on its arguments. 
However, I'm not sure whether you can use 'prepare' for
non-SELECT-statements; have you tried 

$sth->do('INSERT ... VALUES(?)', undef, $phrase) 

instead?

Maybe you should give the dbi-users mailing list (dbi-users@isc.org) 
a try.

HTH,
	Michael.

________________________________________________________
Michael   |  email: hanisch@informatik.uni-muenchen.de 
Hanisch   |                                            
________________________________________________________



Mime
View raw message