how to view a BLOB (image)

[shahzad]

<cfquery datasource='dbsource' username='username' password='password'
name='viewpic'> select image from images where id = 1 </cfquery> <cfset
fullPath = 'C:\folder\abc.jpg'> <cfoutput query='viewpic'> <cffile
action='write' file='#fullPath#' output='#image#' addNewLine='Yes'
nameconflict='overwrite'> </cfoutput> <!--- to show it in the browser---->
<cfheader name='Content-Disposition' value='inline; filename=#fullPath#'>
<cfcontent type='image/jpeg' file='#fullPath#' deletefile='no'>

[RFreese]

For efficiency's sake, is there a way to just send the binary image data to the
browser without the extra I/O and the file maintenence (have to create and
delete temp file on server=slow) of writing the BLOB data to a file as shown in
this solution? I mean, the data is in the database, I don't need another copy
of it on the server even temporarily. Do I really have to write (disk hit) and
read (disk hit) then delete (disk hit) a temp file to send it is my question.

I am now learning CF, but I have to say this was easy code in ASP. Since CF
is "better" why all the extra I/O? I will keep reading the forum, and look
forward to any replies.

Thanks for the clean code example and for any additional advice on the topic.

Roberta

[unleashed]

See my post at:


[url]http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=6&thread[/url]
id=1015900&enterthread=y

It shows you how to stream the image out to the browser without having to
write it to disk.

James
Sacramento, CA