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
