> > I want to insert an uploaded file directly into a SQL database field. So > after the user has uploaded the file to our CF server, at some point later > (probably overnight), we can move this file to store it directly in the db. > > I have no idea how to make a start on this (the file's already uploaded to > the server), it's just the overnight routine I can't work out. > > Does anyone have any help for me???? >
Alex, Do you really need to store the file in the database? You can store files in BLOBs in databases, but they aren't really made for that kind of thing. If you want to send the file out to someone some how, you'll need to extract it from the database, write it to the server and then send it out to the user. Why not just leave the file on the server in the first place and just store a reference to it in the database? What is it you're really trying to do? Regards Stephen ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
