Converting blob to image

[Fernando_Alonso_Aram]

Hi.
Im using script to store filedata as varbinary(max) in mssqlserver.
but the problems comes when im trying to display the image in perspective.
im copying some of the scrips i see in some related topics

I’m using this query to select and convert the blob to base64:

SELECT CAST(’’ as xml).value(‘xs:base64Binary(sql:column(“filedata”))’, ‘varbinary(MAX)’)
FROM files
WHERE filename = ‘04E.JPG’
then this script transform to display the image:

b64Image = “data:image/jpeg;base64,%s”%value
return b64Image

But it doesn’t display anithing, i think some parameter is missing

Can somebody tell me how to fix this problem?

[Transistor]

Tip: use the </> code formatting button to preserve code indentation and apply syntax highlighting. It’s essential for Python and makes any code much easier to read. There’s an edit button (pencil icon) below your post so you can fix it.

[PGriffith]

Make your named query a scalar query.

[Fernando_Alonso_Aram]

i made it scalar query, now it brings this array, but no image is shown.

[PGriffith]

Your query is returning a raw byte array, not a base64 string. You need to adjust your query.

[Fernando_Alonso_Aram]

Thank you so much, I managed to convert the array in string using the embed functions of ignition. as i struggled so much with the scripting, but it does the job.
As i only know ladder prog. Im discovering this phyton programing ,

[pturmel]

Meanwhile, you might want to look at this:

Automation Professionals' Blob Server Module

Automation Professionals is pleased to announce an alpha release of its new Blob Server Module. Available only for Ignition v8.1, here. The Blob Server Module provides a simple way to deliver images, PDF files, or other binary content from a database to your Perspective clients or other web applications. Without needing the WebDev module. All you need is a Named Query that has appropriate security settings and returns a single row with two columns: Content, and ContentType. Modest documentati…

(:

[deepti_k]

i used same code still i am not able to get it.

[Maria_P]

I'm trying to show an image stored in dabatase in vision, with an image object.
should this solution work also for vision module?

I'm showing images in a power table column but its not best approach for that.

[Transistor]

Maria, this thread is for Perspective. I suggest that you start a new thread for your Vision query. Reference this one if it's relevant.