Update one field from another in the same table

[drmaves]

How do I write a query that sets a field within a table to the value of another field from the same table?

[Kronin555]

update table set field1 = field2 where field3 = 'blah';

[drmaves]

Here's what I have now for my query:

<CFQUERY datasource="#application.dsn#">
UPDATE affiliate
SET last_contacted = #affiliate.originated#
</CFQUERY>

This produces the following error:

Element ORIGINATED is undefined in AFFILIATE.

It doesn't want to recognize a field within the table.

[Kronin555]

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>

[drmaves]

Thanks for your help