Coldfusion is not a database. Your database either supports or does not support image or binary storage. You should probably learn about the technology before implementing a solution.
On Fri, 7 Dec 2001, cfmailr wrote: > Joseph, > 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. > > ----- 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
