how to escape from a string

[be12dune09a]

how can I escape from a string a " ' " char to insert it in sql

 

[ishnid]

Learn how to use placeholders: There's a quick tutorial here.

 

[be12dune09a]

sub escapeQuote
{
$class = shift;
$_ = shift;

s/^'(.*)'$/$1/;
s/\'/''/g;
s/(.*)/'$1'/;



return $_;
}

 

[be12dune09a]

I found out

 

[ishnid]

Seriously, placeholders are they correct way to do it - you don't need to worry about escaping ANY characters yourself if you use placeholders correctly.

 

[MikeLacey]

placeholders, use placeholders

Mike

I am not inscrutable.

Want great answers to your Tek-Tips questions? Have a look at faq219-2884

 

[fishiface]

If you can't use placeholders (and, for example, Microsoft Sequel Server doesn't support them via DBD::Sybase) then use the quoting mechanism provided in the DBI library, like it says on the tin.

$quoted_string = $dbh->quote($string);

Why invent your own?

fish


["]As soon as we started programming, we found to our surprise that it wasn't as easy to get programs right as we had thought. Debugging had to be discovered. I can remember the exact instant when I realized that a large part of my life from then on was going to be spent in finding mistakes in my own programs.["]
--Maur