I found this on the list and should work
put "SELECT * FROM pictures WHERE pictures.ID = 3" into theSQL
put revQueryDatabaseBLOB(dbID, theSQL) into curID
put revDatabaseColumnNamed(curID,"picture") into tdata
put tdata into image "ctg1"
but not for me it returns this
% PNG
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Robert Mann
Sent: Tuesday, May 08, 2007 11:07 AM
To: [email protected]
Subject: pictures in mysql database
Have some pictures in a mysql database I am not sure how to get them to
display in my image field this is what I have tried so far
put "SELECT * FROM pictures WHERE pictures.name= 'ctgFork01';" into theSQL
put revQueryDatabase(dbID, theSQL) into curID
put revDatabaseColumnNamed(curID,"picture") into ctg1
set the filename of image "ctg1" to ctg1 -- this did not work
--or this one
put ctg1 into image "ctg1"
anyone know what I need to do to get the picture to display?
Thanks
Rob
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
