Posts made by IAmAMFTRex

I use the following SQL to store a standard JPG image inside a varbinary(max) field:

INSERT INTO Logos(cid,logo)
SELECT 12484, BulkColumn  FROM  OPENROWSET(Bulk  'C:\Logos\12484.jpg', SINGLE_BLOB)  AS  BLOB

Then I have a script attached to my report that queries that table:

async function beforeRender(req, res) {
    await sql.connect(config)
    const sqlReq = new sql.Request();
    const recordset = await sqlReq.query(
        `SELECT * FROM Logos WHERE cid=12484`
    )
    Object.assign(req.data, { logo: recordset });         
	const logo=req.data.logo.recordset;
	req.data.logo=logo;
	console.log(logo);
}```

It seems to grab it fine, but the result looks to be encoded and I'm not sure how to get it displayed as an image.

Thank you for the help but it's still not working - my images are store as jpg's so using:

<img src="data: image/jpg;base64,{{{logo}}}" />

Displays:

��PP
@����t��;��Vї#8,z*���E�"����O��/�[������y�$h�',Ǡ��$�I j�M�z�֡��0��6K�ʯ�

+plus a lot more gibberish

I know it's something stupid I'm not getting but....?

I have images stored in a MS SQL Database table as varbinary(max) and I'm trying to figure out how to display them in JSReport. Currently I'm calling them from a script and want to do something like:

{{#each logo}}
   <img src="{{asset "{{logo}}" "dataURI"}}" />
{{/each}}

It throws errors whichever way I've attempted to do it.

Any suggestions?