On 5 Apr 2006, at 23:37, Devin Asay wrote:
I know this can be done, but it's got me stumped. Nothing
conclusive from archives.
I want to store image data in a mysql database and then show it in
an image object in Rev. I successfully loaded an image into a field
of type longblob. I know the data is there and that it's valid.
This is what I tried to load the image data:
global connID -- my connection id
on mouseUp
if connID is empty then
answer "You need to connect to the database first."
exit to top
end if
put word 2 of the selectedline of fld "linenumbers" into tEntryNum
put "select illustration from vocablist where item_index = " &
tEntryNum into tQuery
put revDataFromQuery(,,connID,tQuery) into tData
set the imagedata of img "testImg" to tData
end mouseUp
Did you try using revQueryDatabaseBlob instead of revDataFromQuery?
Cheers
Dave
_______________________________________________
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
