pictures in mysql database

[Robert Mann]

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: use-revolution-bounces at lists.runrev.com
[mailto:use-revolution-bounces at lists.runrev.com] On Behalf Of Robert Mann
Sent: Tuesday, May 08, 2007 11:07 AM
To: use-revolution at 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 at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution