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

RE: Binary Data and BLOB Problem

2002-12-31 Thread Kevin Wixson
enough to convert to ASP. Mike Hillyer END SHAMELESS PLUG -Original Message- From: Kevin Wixson [mailto:[EMAIL PROTECTED]] Sent: Monday, December 30, 2002 10:29 AM To: [EMAIL PROTECTED] Subject: Binary Data and BLOB Problem Thank you, Kevin Wixson IT Manager Norman Camera Video (616

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

RE: Binary Data and BLOB Problem

2002-12-30 Thread Mike Hillyer
-Original Message- From: Kevin 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

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();