Here you go:
<cfsetting requesttimeout="99999999">
<cfpop server="#srvr#" username="#uname#" password="#pwd#" action="getall"
name="tmail" attachmentpath="#expandpath('/email/attachments')#" >
<cfloop query="tmail">
<cfquery name="check_dups" datasource="#datasource#">
SELECT * FROM inbox where uid = '#tmail.uid#'
</cfquery>
<cfif check_dups.recordcount eq 0>
<cfquery name="inert_mail" datasource="tonyb">
INSERT INTO inbox
(
uid,
messageID,
from_name,
to_name,
cc_name,
subject,
body,
textbody,
htmlbody,
attachments,
header,
date_time,
has_read,
deleted
)
VALUES
(
'#tmail.uid#',
'#tmail.messageID#',
'#tmail.from#',
'#tmail.to#',
'#tmail.CC#',
'#tmail.subject#',
'#tmail.body#',
'#tmail.textbody#',
'#tmail.htmlbody#',
'#tmail.attachments#',
'#tmail.header#',
'#dateformat(ParseDateTime(tmail.date, "POP"),"mmmm dd, yyyy")#
#timeformat(ParseDateTime(tmail.date, "POP"),"hh:mm:ss tt")#',
0,0
)
</cfquery>
<cfoutput>'#tmail.uid#'<br></cfoutput>
</cfif>
</cfloop>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320596
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
