Restore file inserted in varbinary(max)
Hello, everyone.
I'm just learning about how to store a file directly into a database using varbinary(max). I've got the upload/insert working just fine.
Now.. how do I retrieve the file and reconstruct it for download?
I've done some Google-ing on this, and I'm not finding anything helpful.
This is a MS-SQL Server 2005 database, working with a CF9 server. I'm uploading the file to the webserver, then doing a READBINARY and saving it to a variable, then inserting that variable contents (in a CFQUERYPARAM tag) into the database. How do I take the varbinary data and reconstruct the file?
Thanks,
^_^
