I am trying to use CFPOP to look for a certain email address in the
FROM.
I have the address I am looking for stored in my DB.
I know that the email I am looking for is there (I can see it) but when
I try to compare the CFPOP.From to the address in my DB I never get a
match???
Anyone have any ideas???
<!--- Declare Variables--->
<cfquery name="GetVars" datasource="DSN">
select * from settings
</cfquery>
<!--- Get New Mail --->
<cfquery name="getpops" datasource="DSN">
select *
from pop3
</cfquery>
<CFLOOP QUERY="getpops"
STARTROW="1"
ENDROW="#getpops.recordcount#">
<CFPOP
server="#getpops.pop3_server#"
username="#getpops.pop_username#"
password="#getpops.pop_password#"
action="GetAll"
NAME="MailList"
>
<strong>Looking for:</strong> <cfoutput>#GetVars.CLFrom#</cfoutput>
<BR><BR>
<cfoutput query="maillist">
<cfset trimaddress = trim(#mailList.from#)>
<cfif '#trimaddress#' NEQ '#GetVars.CLFrom#'>
</cfif>
</cfoutput>
</CFLoop>
Kris Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
