Hi Ron,
Thanks ... but I don't have that type
of query (the CFIF actually within the
query) in this case. I'm querying the
POP account only, not a DB.
Any other thoughts? Thanks!!
Mark
--- Ron Anderson <[EMAIL PROTECTED]> wrote:
> Most likely in your query structure.
> I usually get those errors around opening or closing
> a bracket near an IF
> statement.
>
> SELECT
> *
> FROM
> foo
> WHERE
> fooID=<CFIF This EQ 1>#foo#<CFELSE>#bar#</CFIF>
>
>
>
> -----Original Message-----
> From: Mark [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 19, 2001 3:44 PM
> To: CF-Talk
> Subject: CFPOP Error
>
>
> Can anyone direct me to the explanation
> of this error message:
>
> unknown exception condition
> CFMLInterpreterImp::executePCode
>
> It's generated while I'm running
> CFPOP to collect email messages,
> check them for a certain word, and
> then send an email to a certain email
> address if the word is contained in
> the subject or body. Then another email
> is generated with all the emails that
> were found with that word. It's basically
> looking for error emails from persons
> that are trying to unsubscribe from a
> list, but did it incorrectly. Here is
> the code:
>
> <CFPOP
> SERVER="mail.server.com"
> USERNAME="[EMAIL PROTECTED]"
> PASSWORD="xxxxxxx"
> ACTION="GETALL"
> NAME="removemail">
>
> <CFSET addrem = "">
> <CFSET norem = "0">
>
> <CFLOOP query="removemail">
>
> <CFIF #trim(removemail.subject)# CONTAINS "remove">
>
> <CFMAIL TO="[EMAIL PROTECTED]"
> FROM="[EMAIL PROTECTED]" Subject="unsubscribe">
> message goes here
> </CFMAIL>
>
> <CFSET addrem = ListAppend(addrem,"#from#")>
> <CFSET norem = norem + 1>
>
> <CFPOP
> SERVER="mail.server.com"
> USERNAME="[EMAIL PROTECTED]"
> PASSWORD="xxxxxxxx"
> ACTION="DELETE"
> MESSAGENUMBER="#trim(messagenumber)#">
>
> </CFIF>
> </CFLOOP>
>
> <CFSET addrem = ListChangeDelims(addrem,"<br>")>
>
> <CFIF norem GT 0>
> <CFMail TO="[EMAIL PROTECTED]"
> FROM="[EMAIL PROTECTED]"
> Subject="removed
> addresses">
> Following addresses were removed:
> #addrem#
> </CFMAIL>
> </CFIF>
>
> Can anyone advise? Thank you!
>
> Mark
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
