Can't you save the text of the message before you extract the attachment? You may need to use a CLOB field.
I don't think CFPOP will let you save attachments to memory rather than a drive, but I'm not positive on that. -----Original Message----- From: Discover Antartica [mailto:[EMAIL PROTECTED] Sent: Thursday, January 20, 2005 12:31 PM To: CF-Talk Subject: Re: Can we save email attachments directly in the database? Got the answer but... But, I want to avoid CF saving it on a folder on the disk and instead go directly to the database. Is there a way? In the example below, cffile is being used to read the file from a folder. I want to skip this step of file being saved in folder first, then being read by cffile and then being put in the database by cfquery. is there a way to do this? Mark Drew <[EMAIL PROTECTED]> wrote: The actual contents of the file or the filename? if its the actual content of the file I guess you should do a if the file is a text file else if text or depending on the file if binary And then INSERT INTO blobs (content) if binary VALUES else VALUES On Thu, 20 Jan 2005 08:18:52 -0800 (PST), Discover Antartica wrote: > Hello, > > I am using . Currently, it is saving files in a folder on disk. I want to save it directly to the database. > > Is that possible with coldfusion? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191241 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
