Thanks for the answers. I have tried to use quotemeta but it did not work as expected, DBI's quote function was exactly what I want.
Thanks again, On Jul 1, 6:35 pm, [EMAIL PROTECTED] (Amit Saxena) wrote: > use > > $*dbh*->*quote*($str) > > On Tue, Jul 1, 2008 at 4:59 AM, Gunnar Hjalmarsson <[EMAIL PROTECTED]> > wrote: > > > Beyza wrote: > > >> I have an array which has strings like; > > >> John's House > >> Bla bla; > >> etc, > > >> When I use them in an SQL query, perl gives an error. So, I need to > >> put escape character for every special character. Is there any quick > >> way to do it? > > > perldoc -f quotemeta > > > -- > > Gunnar Hjalmarsson > > Email:http://www.gunnar.cc/cgi-bin/contact.pl > > > -- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > >http://learn.perl.org/ -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://learn.perl.org/
