It is a bug because it works differently from cf7. And the issue seems to be not that cf is returning the wrong resultset (ie rowcount instead of the identity), it's that it's not returning any resultset at all.
If rowcounts cause these kinds of issues, wouldn't we have issues with pretty much every query? Russ > -----Original Message----- > From: C S [mailto:[EMAIL PROTECTED] > Sent: Friday, February 15, 2008 5:07 PM > To: CF-Talk > Subject: Re: cf8 query weirdness > > >What is this nocount and why do I have to use it. > > > >Also can we confirm that this is a cf8 bug? > > Drivers process the results of each statement. Including those that only > return a rowcount like updates or inserts: ie (1) row inserted. Cfquery > is only supposed to return one resultset. Rowcounts can interfere with > that. Using set nocount avoids that problem. That is not a bug IMO. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299156 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
