Using CFQUERYPARAM, do I need to use CFFILE to get the file onto the server? Or do I just use CFQUERYPARAM with the name of the file upload field as the variable?
Thanks! Pete ----- Original Message ----- From: "Jesse Houwing" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 03, 2003 9:01 AM Subject: Re: Upload binary file and insert into Oracle > Pete Ruckelshaus wrote: > > >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? > > > > > use a cfqueryparam to do the job. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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