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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4