images in mysql through perl dbi interface

Does any know where I can get an image
into a blob type column from a perl dbi script?
tried the following substitutions with no success.

$var=~s/'/'/g;
$var=~s///g;
$var is where the image is located the
insert always barfs
any suggestions how to get it in?

Thanks in advance,

Rick
rick@erealestateforyou.com

[QUOTE]Originally posted by dis:
[B]Does any know where I can get an image
into a blob type column from a perl dbi script?
tried the following substitutions with no success.

$var=~s/'/'/g;
$var=~s///g;
$var is where the image is located the
insert always barfs
any suggestions how to get it in?

Thanks in advance,

Rick
rick@erealestateforyou.com


Here is my way to solve this problem, by using an filehandler $ICONFILE

my $icon;
my $filesize;
if ($ICONFILE ne '') {
$filesize = -s $ICONFILE;
my $in = read($ICONFILE, $icon, $filesize,0);
if ($in != $filesize) {
error("Error reading the file $ICONFILE");
}

$icon =~ s///g; # first do this
$icon =~ s/!Ù‘XÜ‘scrollbarsI¸å‘¨Ô‘0šì
(Ü‘¼n’�Äå‘4Ì‘postusername,H!ðÛ‘(Þ‘
resizable=@±
ðBï‘—
date() [<a href='function.date'>function.date</a>]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. We selected 'America/New_York' for 'EDT/-4.0/DST' insteadHB y@Þ‘HBfalsea@Þ‘HB;I@Þ‘HB 1@Þ‘HBrel@Þ‘HB=°
XÜ‘ÀÞ‘ nofollowA0ã‘(Ì‘-~Õ¨Ü
`Þ‘Ü<’4Ì‘<ã‘timespentB9hã‘`Ì‘ØÞ‘HBclassØÞ‘HB=8 (Þ‘*â‘
inlineimgÁxB_’ ©¸â‘HBsrc‘¸â‘HB=y¸â‘HBhttpa¸â‘HB://