Re^3: Need help escaping literal string

[roboticus]

mrras25:

That's why davido mentioned placeholders. It's something like:

# Prepare a statement...
my $sth = $dbh->prepare("insert into dbtable (vol) values (?)");
my $funky_string = "/vol/enycmmcfl01b_ssd2_home_1b_a/CBirbigl$'s";
$sth->execute($funky_string);

This way, you don't have to worry about the odd characters inside your statement. Building your own statements like you were trying to do just leads to the difficulties you're experiencing. That's why placeholders were invented.

...roboticus

When your only tool is a hammer, all problems look like your thumb.

[mrras25]

OUTSTANDING folks thank you for getting back to me I will give that a whirl and see how that flows...

Again thanks all