Access would choke quickly on this. Go with MySQL.
There's a tag I remember seeing that may help called ActiveScan by Peter Freitag. The user scans an image and its uploaded directly to the site. http://devex.macromedia.com/developer/gallery/info.cfm?ID=72D53CD3-7928-11D4 -83E100508B94F85A&method=Full >From the exchange: Activescan is a development tool for Allaire Cold Fusion� that allows clients to send images directly from their scanner to your web server. This makes it extremely simple for clients to publish photographs, hard copy documents, or anything else that can be scanned -- So what you could do it have the person log into the site first, then do the scanning. larry -- Larry C. Lyons ColdFusion/Web Developer Certified Advanced ColdFusion 5 Developer EBStor.com 8870 Rixlew Lane, Suite 204 Manassas, Virginia 20109-3795 tel: (703) 393-7930 fax: (703) 393-2659 Web: http://www.ebstor.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- > -----Original Message----- > From: FlashGuy [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 04, 2002 10:05 AM > To: CF-Community > Subject: OT : Developing site > > > Hello, > > I posted this question a few weeks ago but have found out > more information since then. I want to do it in CF. I was > told I can use any OS and databases I want. > It does not have to be Access (like before). They want the > process streamlined. Presently, this is how its being done. > > 1. User scans invoices into .tif format and ftp's the graphic > file to a repository on the server (off-site. ISP). > 2. They then log into the website. Click on the graphic file > which opens a template with fields and the graphic below. > They enter in invoice#, company etc. which I assume, > gets stored into a database. > 3. If an image (invoice) has pricing that they don't want a > customer to see then they open up the "master" image. Edit > the graphic and remove what they need and then ftp the > file back to the server again. > > I just found out there will be approximately 25,000 images > posted yearly. Even is I use SQL wouldn't it be best to have > links in the database pointing to the directory and files > rather than include the binary data into the database? > > Would mySQL be sufficent. I would think as I've been told > many times before that Access is not sufficient but I'm just > want clarification. I have the go ahead to get an ISP and I > don't want to screw this up. SHould it be windows or u*x based? > > Your thoughts wonderful guru's!!!!! > > > > --------------------------------------------------- > Colonel Nathan R. Jessop > Commanding Officer > Marine Ground Forces > Guatanamo Bay, Cuba > --------------------------------------------------- > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
