Retrieving BLOB data using MII

[Former Member]

Hi,

Is it possible to retrieve BLOB data from database and display the same in webpage using MII ?

Regards

Muzammil

[former_member201407 · Accepted solution]

Yes its possible. Get that binary code of that data object from DB and put the same as Encoded property of Action Image Saver.

Please let me know if there is any other better approach for the same

Regards

Som

[Former Member · Accepted solution]

Thanks for your reply Som,

But unfortunately its not working.

This is how i did it.

1. Using Query Template i fetched the data and the datatype i used in DB is image

2. In BLT, i tried applying the output of Query Template to EncodedImage variable of Image saver

Image file is getting saved but showing invalid Image while opening and the size of file is zero

Regards

Muzammil

[former_member201407 · Accepted solution]

Please can u open the output of the Query Template in xml format, and see what number for SQL Datatype for that fetched image data is showing?

Not sure, but try with encode() function on this data and pass this to EncodedImage of ImageSaver

Regards

Som

[Former Member · Accepted solution]

Som,

SQLDataType is - 4.

I tried encode/decode functions. No luck.

Muzammil

Edited by: Muzammil Ahamed on Jul 8, 2010 4:09 PM

[Former Member · Accepted solution]

Guys,

Any Luck?

Regards

Muzammil

[agentry_src · Accepted solution]

Which version and build of MII are you using?