Sorry for the missing detail. It is SQL Server 2000. -----Original Message----- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 23, 2006 8:28 AM To: CF-Talk Subject: Re: Storing lots of files
Which DB are you using? On 8/23/06, E C list <[EMAIL PROTECTED]> wrote: > Hello, > > I was looking for some advice on the best way to deal with thousands of files (PDFs or TIF files of contracts and paper relating to the contracts) using ColdFusion 5.0. > Here is the scenario: We are purchasing a sharp copy machine that is > networkable. One of the best features of this machine is that it will email scans of documents to an email address. What I plan to setup is a system whereby when a salesman brings in a contract, s/he puts it in the copy machine, and sets it to email a copy of the document to an email address monitored by ColdFusion. In the subject line, they will put in a unique ID for that customer and possibly a description code (ie- Contract, Check, Material Order, etc...). ColdFusion will pick up the email message, do something with the file attached and pop at least the description into the database with the customer's ID number to key it against the customer's record so that it could be retrieved remotely as needed. The question I have is what is the best way to handle those documents on the server? Should they be stored as files in a single directory (Windows 2003 Server), should they be put in some kind of subdirectory system, or should they be inserted into the database? If the later, can anyone give me an idea or point me to a resource that would describe how this is done with ColdFusion 5, as I haven't ever actually done any work where files are kept in the database. -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250716 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
