INTO DUMPFILE, BLOB problem

2003-02-28 Thread Interware \(Roboz\)
Hi All, Please help me, how can I download, store or read a content of an BLOB field to the local filesystem via the internet. I have tried it, but it wasn't right: SELECT Picture INTO DUMPFILE "C:\TempFile" FROM article where `ColumnID`=1 and `ArticleID`=4; It stores the file to where the sql s

RE: Binary Data and BLOB Problem

2002-12-31 Thread Kevin Wixson
QL (obviously I'm doing something wrong, else I wouldn't be getting errors using the AppendChunk method) or with converting the data into a binary type so it can be written to the adTypeBinary type Stream object. At 05:01 PM 12/30/2002 -0700, you wrote: Hi Kevin; You may want to lo

RE: Binary Data and BLOB Problem

2002-12-30 Thread Mike Hillyer
Wixson [mailto:[EMAIL PROTECTED]] Sent: Monday, December 30, 2002 10:29 AM To: [EMAIL PROTECTED] Subject: Binary Data and BLOB Problem Having trouble with my first MySQL database. I want to upload and install image files to a database for online sample photo gallery for our customers. The system

Binary Data and BLOB Problem

2002-12-30 Thread Kevin Wixson
Having trouble with my first MySQL database. I want to upload and install image files to a database for online sample photo gallery for our customers. The system I've created so far sometimes works, sometimes doesn't. It seems to depend on the size of the file being uploaded, but tests have be

blob problem

2002-05-06 Thread Chirag
hi, I want to insert binary structure into the mysql blob column. I have a my own structure called MSG_STRUCT msg_struct; Now i want to insert the whole structure (binary) into table having a column of blob data type. I tried by end = strmov(query,"INSERT INTO retry (msisdn, msg) values(");