Pulling BLOBs from Database

[jl_forum]

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

[atween]

Did you figure this out?