Re: LOAD_FILE does not work

2001-11-21 Thread Sharaaz Khan
OTECTED]> Sent: Wednesday, November 21, 2001 2:08 PM Subject: Re: LOAD_FILE does not work > > - Original Message - > From: "Carsten H. Pedersen" <[EMAIL PROTECTED]> > To: "Sharaaz Khan" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: W

Re: LOAD_FILE does not work

2001-11-21 Thread Sharaaz Khan
- Original Message - From: "Carsten H. Pedersen" <[EMAIL PROTECTED]> To: "Sharaaz Khan" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, November 21, 2001 1:52 PM Subject: RE: LOAD_FILE does not work > > I have been trying to

Re: Fw: LOAD_FILE does not work

2001-11-21 Thread Mike(mickalo)Blezien
On Wed, 21 Nov 2001 17:02:29 -0500, Christopher Book <[EMAIL PROTECTED]> wrote: UPDATE Software SET Description = >>LOAD_FILE(/usr2/home/khan/www/cgibin/protecting/Describe/description_file) >>WHERE ID = 9 >> >>You have to make sure that not only can mysql read the file, but it also has >>

Fw: LOAD_FILE does not work

2001-11-21 Thread Christopher Book
>>UPDATE Software SET Description = LOAD_FILE(/usr2/home/khan/www/cgibin/protecting/Describe/description_file) WHERE ID = 9 You have to make sure that not only can mysql read the file, but it also has permissions to the directories that the files are in. Typically your home directory on your se

RE: LOAD_FILE does not work

2001-11-21 Thread Carsten H. Pedersen
> I have been trying to load the textual contents of a file from my > hard drive > space into a field (Description) of my mySQL table (Software) using the > follwing query. The query runs succfessfully How do you know that it's successful? What success/error codes (if any) are returned? > >

Fw: LOAD_FILE does not work

2001-11-21 Thread Sharaaz Khan
I have been trying to load the textual contents of a file from my hard drive space into a field (Description) of my mySQL table (Software) using the follwing query. The query runs succfessfully, however, none of the contents are loaded into the field, in fact, the Description field is not updated