I suppose one solutions, while it is a bit more work would be to have
osmething like:
<cfquery ...>
DECLARE @record_count INT;
SET @record_count = ISNULL(
(
SELECT COUNT(*) AS record_count FROM [TABLE] WHERE.... < where clauses >
),
0
);
<!--- Now run update --->
UPDATE..... WHERE......
<!--- Select the recourd count. --->
SELECT
@record_count AS RecordCount
;
</cfquery>
.......................
Ben Nadel
www.bennadel.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238191
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
