Display blob image from database

[BigSchottkyD]

I have been looking over code in these forums to load an image from the mysql database and have not had much success, I am using version 7.9.2

can anyone share code to display this in a paintable canvas, label, or image component?

here is my query:

presentation = event.source.parent.getComponent('Dropdown').selectedLabel
rowSlide = event.source.parent.currentSlidePath

image = system.db.runScalarPrepQuery("SELECT photo FROM presentations where presentation=? and series_name = ?", [presentation, rowSlide])

[abishur]

I did this also, check this thread here:

Load image from DB into Image object

I’ve successfully followed the examples on the forum to upload an image into an SQL database as a BLOB. I’ve also been able to create a custom property of type dataset on my window that successfully reads the BLOB into itself. I’m stuck on the last step though, now that I’ve got this, how can I put an Image Display object on the screen and display the BLOB inside it?

for the code I used and the solution provided to me to get it to work correctly.

[BigSchottkyD]

Thanks abishur,
I saw your post and tried that earlier with no luck. I keep getting some errors.

File “event:propertyChange”, line 18, in
AttributeError: ‘NoneType’ object has no attribute ‘width’

[abishur]

Can you post the code you’ve done as a reference?

[BigSchottkyD]

Edit:

The problem was that I did not save the blob correctly in the database. The label code is good though.