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:250709 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
