Retrieving PDF as BLOB from SQL DB

[Paulduke]

I need to figure out how to retrieve a PDF files, stored as BLOBs in a SQL Server 2005, and write them to the browser and/or file directory on my webserver. I'm inheriting the database for a new website I'm building using ColdFusion 8.

[-__cfSearching__-]

Ben Nadel's blog has a good example of streaming binary data.  The examples use images. But the same concept applies to pdf's. Just change cfcontent's mime/type

http://www.bennadel.com/blog/1274-ask-ben-streaming-binary-data-from-the-database-blob-to-the-user-using-coldfusion.htm