Re: How do I update a single column?

Hey El,

   You can do this with a SQL statement pretty easily:

UPDATE <table> SET <field> = '<value>'

this will update all the records in the table, setting the field you
specify to the value you specify. You can prevent it from updating
everything in the database using a WHERE clause if need be (i.e. WHERE
<field> = '<value>').

An example in CF:

<cfquery name="myQuery" datasource="#myDs#">
UPDATE a_myTable SET myField = 'yes'
</cfquery>

Not that looping through each record and updating it individually
13,000+ times won't work (it will) but this UPDATE SQL will get the
job done in about 2 seconds vs. however long it would take to parse
and update 13,000+ records one by one! :) Hope this helps!

-- Denny