I only want to store the NEW Message in the database as I would already have the original message stored in the DB.
Since the BODY of the old message would contain the headers and stuff, I was wondering if anyone had done this before. Randy Adkins >>> [EMAIL PROTECTED] 05/21/02 13:13 PM >>> > I have two questions regarding the query columns > returned from using CFPOP. > > 1. The date field when it comes in is not a TRUE > date field thus I can not use CreateODBCDate or > DateFormat on this field to grab JUST THE DATE and > then JUST the time. IDEAS??? This really depends on your mail server - but why not ParseDateTime() to make it into a real Date type? Then you can use DateFormat() and TimeFormat() as much as you want > 2. Any idea on how to grab the NEW MESSAGE and NOT > the replied message. Meaning if this is a reply to > an original message I do not want the original message > but the NEW message. > ANY IDEAS ON THIS? Why not store the messages in a database (read via CFPOP on a schedule) and then you can do whatever you want with it... Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
