Image upload component

[deepti_k]

I’ve successfully followed the examples on the forum to upload an image into an SQL database then I am trying to retrieve the saved image from database and show it in image component in perspective. I tried different ways but none of them seems working. In db dataType is varbinary(Max).
I am trying;
query as:
SELECT CAST(’’ as xml).value(‘xs:base64Binary(sql:column(“file_stream”))’, ‘varchar(MAX)’) from
Files where name =‘Photo.png’

path=“selectphoto”
v=system.db.runNamedQuery(path)
return {‘contentType’:‘image/png’,‘bytes’:v}

Thanks in advance.

[Transistor]

Please use the </> code formatting button when posting code. You can edit your post with the pencil icon button.

[victordcq]

@pturmel made a module for fetching blobs from a database

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…

[pturmel]

@deepti_k

v=system.db.runNamedQuery(path)
return {‘contentType’:‘image/png’,‘bytes’:v}

The above is wrong. v is not an array of bytes. It is a dataset. You need to access the row/column containing the blob. If the first row, as typical, your code should look like this:

ds = system.db.runNamedQuery(path)
v =  ds.getValueAt(0, 'myBlobColumnName')
return {'contentType':'image/png','bytes':v}

[PGriffith]

Or switch your named query type to be a ‘scalar’ query.

[deepti_k]

thanks it’s working