Skip to main content
P
Paulduke
Participant
September 17, 2009
Question

Retrieving PDF as BLOB from SQL DB

  • September 17, 2009
  • 1 reply
  • 2177 views

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.

This topic has been closed for replies.

1 reply

-
-__cfSearching__-
Inspiring
September 17, 2009

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

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices