I have to ask, why bother? You've already got the file onto your app server's filing system, just add a reference to the file in the DB. Why bother adding another stage to the process of uploading the file? Why add it to the database, when databases were never intended as file storage devices? Why bloat your database with binaries needlessly?
Just my feelings on storing files in databases. Feel free to ignore me. Regards Stephen ----- Original Message ----- From: "Pete Ruckelshaus" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 03, 2003 1:59 PM Subject: Upload binary file and insert into Oracle > I've never inserted files into a database before, so I just want to ask some questions. Also, please don't respond with "Just store the files on the server's file system and not in the database"...I'm rebuilding an existing app and this is the way it works. > > I have an interface where a user will select and upload a binary file; this file will then be stored in an Oracle 8.0.4 database. All of the stuff on the database side of things are set up since it's a working app now (written in PL/SQL, being rewritten by me in CF5). > > Here is what I assume the steps will be: > > * User selects file in form. > * Upon submission, use CFFILE to save the file to the app server's file system. > * Do a SQL INSERT to insert the binary file into the database...but how? > > It's the last step that eludes me. What do I do? > > Thanks > > Pete > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
