> As for the SET NOCOUNT ON and SET NOCOUNT OFF, they have no > effect on > these. The only thing that does is prevent extra > network traffic by > stopping the extra reporting of how many rows were affected > for each > piece of the query.
In CF8 it did have an effect on cfquery's in some situations. Specifically the simple INSERT followed by SELECT scope_identity() scenario. I do not about CF9. Though I will say the results in CF8 varied greatly depending on a number of conditions (statement used, driver version, etcetera). A lot of the issues were related to how the generated keys feature was implemented. http://www.mischefamily.com/nathan/index.cfm/2008/1/28/Problems-with-CF-8s-Generated-Keys-Feature ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330259 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4