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.
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
Retrieving data ...