Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help retrieving BLOBs into files from ColdFusion

Status
Not open for further replies.

JLForum

Programmer
Jul 23, 2004
3
US
Hi guys,
Any help here would be most appreciated. I have a table, one field of which is type BLOB. I wish to extract this data using a Coldfusion page and have the user be able to save it (similar to an attachment). I have my reasons for not placing the data elsewhere and linking it. I would appreciate it if someone could help me out with a little code here. The BLOBs are already inserted, so that isn't really an issue. Just retrieving it. For example:

A .zip file is saved in the BLOB. There is a field, fileName, which holds the original filename of the BLOB. I want to get the user to be able to retrieve this by inserting a value (Primary Key), which will do a query, and retrieve the appropriate file, allowing them to "save as", similar to attachments. Any help would be most appreciated. Thanks again!
Sincerely,
JL
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top