Not to be rude, but...please reread sentence 2 of paragraph 1 of my original post. Believe me, the goal IS to get the files onto the file system, but it's not going to happen with this release of the app that I'm building.
Pete ----- Original Message ----- From: "Stephen Moretti" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 03, 2003 9:22 AM Subject: Re: Upload binary file and insert into Oracle > 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
