This content has been marked as final. Show 4 replies
update table set field1 = field2 where field3 = 'blah';
Here's what I have now for my query:
SET last_contacted = #affiliate.originated#
This produces the following error:
Element ORIGINATED is undefined in AFFILIATE.
It doesn't want to recognize a field within the table.
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:
SET last_contacted = originated
Thanks for your help