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
