.Recordsaffected or @@RowCount

[Phillip Senn]

Is there a way in native ColdFusion, without going through a SQL Server stored
procedure, to get the number of records affected by an UPDATE stmt?
I can't rely upon a SELECT stmt being executed after the UPDATE stmt, because
someone else may have done another UPDATE or an INSERT.

[PaulH]

use something like

SET NOCOUNT ON
UPDATE table ...
SELECT @@ROWCOUNT as updatedRows
SET NOCOUNT OFF

in your cfquery.