At 1:50 AM +0200 5/6/06, Marco Bambini wrote:
On Jun 5, 2006, at 12:20 AM, Dr Gerard Hammond wrote:
At 8:57 AM +0200 28/5/06, Marco Bambini wrote:
This is a very simple example:
// create a dummy table
db.SQLExecute("CREATE TABLE images(picture BLOB)")
// insert an image into the BLOB column
Dim rec As New DatabaseRecord
rec.BlobColumn("picture") = GetMyPicture
db.InsertRecord ("images", rec)
db.Commit
How would I do this via SQL?
db.sqlexecute("INSERT into images (picture) values (???????)")
You can't Gerard, the only workaround could be to encode your image
with Base64 for example.
Obviously this approach isn't very efficient.
Oh, that is a pity.
OK, so I took the small jpg file, conveted it into a string (via a
lib from Norman [EMAIL PROTECTED] and then I Base64
encoded the image.
Grear, except now when I upload this image I get an error
"Error while trying to send BUFFER to remote server"
"Error while trying to send HEADER to remote server"
Does this mean that JPEGs can't be uploaded into a BLOB field using SQL.
In the SQLpluingPro there appeared to be a method 'SQLiteEncodeBinary'
Did that method make it into the REALSQL plugin?
--
Cheers,
Dr Gerard Hammond
Bioinformatic Analyst
Garvan Institute of Medical Research, Sydney, Australia.
PowerPC Mac the world's most advanced obsolete computer.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
