This content has been marked as final. Show 6 replies
I did look up cffile to use for this; however, the destination
attribute, which is required, won't accept a database as a value. I'm
not uploading to a server or a directory, so unfortunately, it's not
helpful. But thanks.
You are going to have to. As far as I know, you can not load a file
directly from a client to a database server through a web server without
first loading the file to the web server. I would imagine the steps
would be something like this.
Form to collect file to upload.
Action page to load file to web server directory
File is read from web server
Store file in database.
See Bob Dobbs' link above. Search for "cffile" in that page. It's probably the best copy-and-paste example you're going to find.
<previous edit makes remainder of contents irrelevant />
Read the file contents with CFFILE into a variable.
Create a procedure that INSERTS a passed value into the field. It should be IMAGE datatype. Pass the variable to the stored procedure or insert query.
It'd be nice to skip the Access step, BTW.