Read Binary File

Forum|Forum|14 years ago
September 22, 2011
2 replies
2245 views

I have Users Upload files and they are stored in the database as binary file with cf_sql_blob type, it could be a word doc or pdf file but not images

The content type I am storing in the database also. How do I make this file viewable on the browser?

This topic has been closed for replies.

Owainnorth

Inspiring

How do I make this file viewable on the browser?

Bear in mind that whilst this will work for a PDF, a Word doc will just prompt for download.

-

-__cfSearching__-

Inspiring

How do I make this file viewable on the browser?

>> Bear in mind that whilst this will work for a PDF, a Word doc will just prompt for download.

All depends on the browser settings. If the user's browser is capable of displaying the returned file "inline" it will. Otherwise, the user will be prompted to download / open the file.

-

-__cfSearching__-

Inspiring

Run a SELECT to retrieve the binary data. Then use cfcontent to return it to the browser.

The forum eats tags. So fix up as needed

ie

[cfheader name="Content-Disposition" value="inline; filename=theFilenameYouWant.ext"]

[cfcontent type="(mime type of current file)" variable="#binaryData#"]

http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7c82.html

U

umuayoAuthor

Inspiring

What if I want to open it with a Cffile tag

Owainnorth

Inspiring

What if I want to open it with a Cffile tag

Read the documentation and see how the cffile tag works?

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded