> > Simple. The old and the new app need to be able to run in parallel until we > completely retire the old app, which should be ~90 days after release. I > rebuilt an app that took 2 people 7 months to build; I did it alone and in > two months (not by choice, but because I had sharp, heavy objects being > thrown in my general direction). This is a mission-critical app and we want > to make sure that all is well with the new app before we put the old one out > to pasture. > > And, yes, it IS an awful lot like flying by the seat of ones' pants. > No... Sounds like very good practice to me. Flying by the seat of your pant would be switching the old app off with out an overlap. ;o)
And now it really occurs to me why you need the files in the database...... Because you need both apps running in parallel for 90 days and if the new app doesn't write the files into the database and if it goes wrong you "lose" a lot of the data/files that were entered, plus anything added to the database by the new app won't be visible to the old app. Going back to what you asked about CFQUERYPARAM. > 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? > I confess that I've never done this before (being a anti-DB-as-a-file-store fanatic), but I believe you should just be able to give the form variable containing your file to cfqueryparam as the value with the appropriate cfsqltype. Having had a look though, it doesn't appear that there is a BLOB type for cfqueryparam. I think you need to look at the IsBinary/IsBase64 and ToBinary/ToBase64 functions to be able to make sure that the data is in the right format when you insert it. If I remember correctly, files in form data are in base64, so you'd do INSERT INTO BlobField VALUES #ToBinary(form.filefield)# Hope this helps get you closer to your goal. Regards Stephen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
