LiveCode Forums.

in the card I have image "ctgfork01"

I then tried to update the mysql database using

put base64Encode(image "ctgfork01") into tBase64ImgData

put 123456 into tImgID

put "UPDATE pictures SET picture = :1 WHERE id = :2" into tQuery

recExecuteSQL dbID, tQuery, "tBase64ImgData", "tImgID"


in the ...

this is the mysql picture table
ID int
name varchar 20
picture longblob

I see another post here were you insert picture using base64encode, put I did not use rev to insert the picture, can use the base64decode to retrieve the picture still?

I don't know, how do I find it out?

have a table with flds id and picture which is a blob
trying to get the picture from database and display it in a image fld tried this but does not work

put "SELECT * FROM pictures WHERE pictures.ID = 3" into theSQL
put revQueryDatabaseBLOB(dbID, theSQL) into curID
put revDatabaseColumnNamed ...