I'm trying to access images stored in SQL in binary format using ColdFusion.?

This is the code I am using and I think I am close but it's not displaying the image.

<cfsetting enablecfoutputonly="yes">

<cfquery name="getimages" datasource='AIEnterprise'>
select imagedata from images where imageid = '1947'
</cfquery>

<cfcontent type="image/jpeg; charset=ISO-8859_1">

<cfheader name="Content-Type" value="image/jpeg">

<CFSCRIPT>
writeOutput (ToString(GetImages.imagedata ));
</cfscript>

PS: In order to get the writeOutput line to pring out semi-correctly on the screen, I had to add spaces so that is not the actual probelm in case you notice the spaces. I just did that for posting.

Thanks!
Lora

Well, it looks like you are assigning a charset where none should be applied (this is a binary stream, not a JPG) and you're converting to a string your binary stream (again, it's not a string).

<cfsetting enablecfoutputonly="yes">

<cfquery name="getimages" datasource='AIEnterprise'>
select imagedata from images where imageid = '1947'
</cfquery>

<cfcontent type="image/jpeg">

<cfheader name="Content-type" value="image/jpeg">
<cfheader name="Content-Type" value="image/jpeg">

<cfoutput query="getimages">
#imagedata#
</cfoutput>