How to Get image from database and displayed in image viewer

[Farheen_Qureshi]

I am using MSSQL and trying to get image from database

i have done in this way but it is not displaying in image viewer what to do can somebody help me

[victordcq]

You are pasting a dataset into it. you will have to get the the value from out the dataset.
{value}[0,0] (i think, I usually set the return format to json, so not sure)

Note: This method will not work if you images are to big. If its to big you will have to use something else like 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…

[Farheen_Qureshi]

No its not working and from where i can get Blob Server

[victordcq]

Just tested and this was correct

@victordcq

{value}[0,0] (i think, I usually set the return format to json, so not sure

So you have something else. Show the result/error, are you sure the img stored is base 64 and is a png?

Its somewhere in the topic i linked, a post from pturmel

[Farheen_Qureshi]

yeah its working thanks!!