cfml

Hi all

I am trying to read an image stored in the database in binary Base64. I am able to retrieve it using the following line of code:

*`&lt;cfcontent type="image/png,image/jpeg, image/gif" variable="#documentimage#"&gt;`*

However, i want it to display as a thumbnail on the page as at present it just just takes over the entire page. Is there anyway to do this. Help would be much appreciated

If its base64 encoded then you should be able to do it inline like so `&lt;img src="data:image/png;base64, #documentimage#"&gt;`

image.png

thanks <@U06UM62GN> when I use that, I get this displayed:

OK, so I guess you need to convert from binary.

is that using someting like ReadFromBinary

this may do it `&lt;img src="data:image/png;base64, #toBase64(documentimage)#"&gt;`

perfect! thanks ever so much :pray::skin-tone-2: <@U06UM62GN> that did it

One more thing if you wouldnt mind..

As well as converting to Base64, I need to encrypt the image to. I have tried encrypt, decrypt but missing something as getting errors

What do you mean by encrypting an image? You want to encrypt the base 64 string you store in the database?

Yep thats what they have asked for so as well as storing it as binary they also want the image to be encrypted and of course decrypted when outputting the image using the tag you just kindly provided me with

`&lt;!---=== ENCRYPT &amp; STORE THE DOCUMENT===---&gt;`
	`&lt;cfquery name="insertimage"&gt;`
					
	 `UPDATE dbo.boi_beneficiaries_individualinfo`
	  `SET documentImage = &lt;cfqueryparam CFSQLType="CF_SQL_BLOB" value="#ToBase64(FileReadBinary(Form.FileContents))#"&gt;`
	 `WHERE boibeneficialownerID = &lt;cfqueryparam value="#arguments.boibeneficialownerID#" cfsqltype="CF_SQL_VARCHAR"&gt;`
							
	`&lt;/cfquery&gt;`

OK so you'd have to encypt the base 64 string before it is saved as binary

So would it eb jsut &lt;cfset documentinage = #encrypt(theimage)#&gt;

and then the vase 64 line