I saw this post on the cftalk list and was wondering if you have actually stored files in a database and been able to successfully retrieve them from the database, manipulate and then place them back with ColdFusion? Does ColdFusion support the storage of image files in a database yet? What about pdf and other types of files?
We have a client/server software package that stores all the files in the db that we are currenly rewriting in ColdFusion, but someone on the team has the idea that CF does not support file storage in the db. Any comments are greatly appreciated. Suzanne ----- Original Message ----- > From: "Joseph DeVore" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, November 23, 2001 3:24 PM > Subject: RE: Importing data thru web browser > > > > Pardeep, > > > > What type of files will the user be uploading? > > > > If they are larger files, most likely you'll want to use CFFILE > > (action=upload) to write them to disk and store them in a directory that > is > > somehow associated with the user. > > > > At a later time when you want to output only one file, use CFFILE > > (action=read) to read it. > > > > When you want to view all of the files in a directory for a particular > user, > > use CFDIRECTORY. > > > > If it's a smaller file you might consider storing it in the db. > > > > IMO, it really depends on what type of file it is and what you will be > using > > it for, how often you will be accessing it and how large the files are. > > > > If it's an image, storing it in the DB most likely would not be the best > > idea (in most cases, it is faster to call the image from the server rather > > than the db) > > > > TIP: On your upload form use: <form enctype="multipart/form-data"> > > > > Let me know if you have any questions and I will try help. > > > > Joseph DeVore > > VeloxWeb Technologies > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
