File Upload - SQL 2008 FileStream

Question

Hi,In SQL 2008, there is something called FILESTREAM.  It is a new feature of SQL Server 2008, which allows storage of and efficient access to BLOB data using a combination of SQL Server 2008 and the NTFS file system.Has anyone used ColdFusion to upload a document into a database table that has filestream columns? I want to know how I can upload a document from ColdFusion and get it into the database.Any help appreciated-ws

JR__Bob__Dobbs-qSBHQ2 · Answer

Here are the basic steps for uploading a file and storing it in your database.

1. Create a page with a form that includes a file tag. This form will submit to an 'action.cfm' page. Note the name of the .cfm page is not important, 'action.cfm' is an example.

2. On your 'action.cfm' use CFFILE with action="upload" tag to save the file to your filesystem.

3. Use the CFFILE tag with action="readbinary" to read the contents of the uploaded file into a variable. You may also want to use CFFILE to delete the uploaded file after it has been read into a variable.

4. Use CFQUERY with CFQUERYPARAM to insert the file conents.

Please reply if you have more questions.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded