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 --------------------------------------------------- ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
