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 variable ...

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(curID,"...