Hi All,
I wondered if any can shed some light on this.
Basically, I am executing an SQL query to MySQL, but what I need to do is
escape the ' character inside a scalar, like this :
$auction_id = param('auction_id');
$window_title = param('window_title');
$auction_title = param('auction_title');
$startbid = param('startbid');
$description = param('description');
$jpeg = param('jpeg');
$filename = param('filename');
$auction_name = param('auction_name');
$statement=q{UPDATE
auctions
SET
windows_title = '$window_title',
auction_title = '$auction_title',
startbid = $startbid,
description = '$description',
jpeg = '$jpeg',
filename = '$filename',
auction_name = '$auction_name'
WHERE
auction_id = $auction_id};
Why does the escape the $ character if it is meant to how can I just get it
to escape the contents of all the scalars?
Many thanks,
Kevin Smith
_______________________________________________
ActivePerl mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
