Are you running 4.5.1SP2? There were several CFPOP fixes in that release
that could possibly take care of your problem.
Debbie
> -----Original Message-----
> From: Mark [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 19, 2001 8:18 PM
> To: CF-Talk
> Subject: RE: CFPOP Error
>
>
> 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
