[EMAIL PROTECTED]>
Cc: <
Sent: Friday, February 01, 2002 5:57 PM
Subject: Re: LOAD_FILE over SMB filesystems
> At 17:47 + 2/1/02, Kevin Smith wrote:
> >I don't get an error message... I'm actually running the script from the
> >shell > prompt, so I'm t
; <- disconnect= 1 at blob.cgi line 26.
> -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x81bcd04)~INNER)
> <- DESTROY= undef during global destruction.
> -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x81b34a0)~INNER)
> <- DESTROY= undef during global destructio
Paul DuBois wrote:
> At 11:32 -0600 2/1/02, Gerald Clark wrote:
>
>> The single quotes around $image prevent perl from substituting the
>> value.
>> You are trying to load a file named $imageFN.
>> $SQL = "UPDATE banners SET image=load_file(\"$imageFN\") where id=1";
>
>
> But the single quote
ruction.
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Kevin Smith" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 01, 2002 5:43 PM
Subject: Re: LOAD_FILE over SMB filesystems
> At 17:41 + 2/1/02, Kevin Smit
at you get.
What is it?
>
>- Original Message -
>From: "Paul DuBois" <[EMAIL PROTECTED]>
>To: "Gerald Clark" <[EMAIL PROTECTED]>; "Kevin Smith"
><[EMAIL PROTECTED]>
>Cc: <[EMAIL PROTECTED]>
>Sent: Friday, February
MAIL PROTECTED]>
Sent: Friday, February 01, 2002 5:37 PM
Subject: Re: LOAD_FILE over SMB filesystems
> At 11:32 -0600 2/1/02, Gerald Clark wrote:
> >The single quotes around $image prevent perl from substituting the value.
> >You are trying to load a file named $imageFN.
> &
ROY for DBD::mysql::db (DBI::db=HASH(0x81b34a0)~INNER)
<- DESTROY= undef during global destruction.
- Original Message -
From: "Gerald Clark" <[EMAIL PROTECTED]>
To: "Kevin Smith" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 01,
At 11:32 -0600 2/1/02, Gerald Clark wrote:
>The single quotes around $image prevent perl from substituting the value.
>You are trying to load a file named $imageFN.
>$SQL = "UPDATE banners SET image=load_file(\"$imageFN\") where id=1";
But the single quotes are within a double-quoted string. So
The single quotes around $image prevent perl from substituting the value.
You are trying to load a file named $imageFN.
$SQL = "UPDATE banners SET image=load_file(\"$imageFN\") where id=1";
Kevin Smith wrote:
>After reading some other posts on inserting a image into a blob field, I
>tried using
After reading some other posts on inserting a image into a blob field, I
tried using DBI to insert and the following does not work...
I've double-checked the path and it is correct.
$imageFN = '/var/www/htdocs/corporate/images/homenew.jpg';
$SQL = "UPDATE banners SET image=load_file('$imageFN')
On Wed, 2002-01-23 at 07:42, Egor Egorov wrote:
> Panos,
>
> Tuesday, January 22, 2002, 5:42:20 PM, you wrote:
>
> PM> I have some problems loading files into blobs when the file
> PM> resides on a network filesystem e.g. SAMBA. I use mysqld
> PM> 3.23.43-nt.
>
> PM> e.g.
>
> PM> UPDATE Readi
Hello everyone,
I have some problems loading files into blobs when the file resides on a network
filesystem e.g. SAMBA. I use mysqld 3.23.43-nt.
e.g.
UPDATE Reading SET Data=LOAD_FILE("//linbox/log/travel/001.jpg") WHERE id=1;
Query OK, 0 rows affected (0.05 sec)
Rows matched: 1 Changed:
12 matches
Mail list logo