You can use cfpop to get the message from an email account: http://www.techfeed.net/cfQuickDocs/?cfpop then dump it into your db using the appropriate column type (something that can hold that much data). It might be better to parse the message to strip out the parts you want to keep.
> -----Original Message----- > From: Les Irvin > Sent: Thursday, February 16, 2006 10:27 AM > > Can anyone give me an idea how to programmatically insert email into a > database using cold fusion? I'd like to take a daily digest > post from a > mailing list and have it automatically inserted into a > database. Possible? [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232479 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
