You're not supposed to put ## around it. That makes
Coldfusion look for a variable named "originated" inside a
structure named "affiliate", which obviously isn't what you want to
do.
In my query, I didn't have any hashes around field2.
Change your query to:
<CFQUERY datasource="#application.dsn#">
UPDATE affiliate
SET last_contacted = originated
</CFQUERY>