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: use-revolution@lists.runrev.com 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 use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution