Not sure what database you're using. Mssql has @@rowcount which "returns the number of rows affected by the last statement". You could return the @@rowcount and use that value in your cfif. Most databases have something similar.
<cfquery name="UpdateRecord" ..> UPDATE TheTable SET Blah = 'blah' WHERE id = 3 SELECT @@RowCount AS RowsUpdated </cfquery> <cfif UpdateRecord.RowsUpdated gt 0> something was updated <cfelse> nothing was updated </cfif> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273309 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
