cfpop question
I'm just getting started with trying to implement an automatic unsubscribe program, and am stymied. So far, I have:
<cfpop action="getHeaderOnly" name="getMessages" server="mail.comcast.net" username="username" password="password">
<cfif #getMessages.recordCount# IS NOT 0>
<!--- if there are new messages, loop through them --->
<cfloop query="getMessages">
<cfif subject IS "Remove">
<cfquery datasource="cpac">
DELETE FROM Subscribers
WHERE Email=#getMessages.from#
</cfquery>
</cfif>
</cfloop>
</cfif>
I've sent an email message from my email account to my email account with "Remove" in the subject line, and get the following error message:
Error executing database inquiry.
Syntax error (missing operator) in query expression 'Email=earachefl@comcast.net"
The error occurred in (template path)
35: <cfquery datasource="cpac">
36: DELETE FROM Subscribers
37: WHERE Email=#getMessages.from#
I can tell by a cfdump that my messages have been retrieved properly, and can tell that the template has found a message with the subject "Remove", and wants to execute the query.
What exactly is the missing operator in my query?
Thanks.
