I was skimming thru many articles, yet I couldn't find anything on this problem:
I'm trying to update/insert into a Sybase database using the Sybperl module. The problem is one of the values that needs to be set may contain a single quote from time to time.
For example, the value would be something like:
RunSql "delete sometable where strike like '%A-Za-z
I've tried many different things, even escaping all non-characters. When the line is run, it croaks.
$test = q/RunSql "delete sometable where strike like '%[A-Za-z]%'"/;
$test =~ s/(['%\[\]\\])/\\$1/g;
$sql = "update job set cmd='". $test ."' where jobname='somejob'";
Thanks for any help.