I found this thread on HoF. I'm running into the same issue, I'm doing an INSERT INTO SELECT and no resultset is available from the query.
Was there any word on whether this was a bug or not? Thanks. Adrian http://www.adrianlynch.co.uk/ -----Original Message----- From: Russ [mailto:[EMAIL PROTECTED] Sent: 15 February 2008 23:01 To: CF-Talk Subject: RE: cf8 query weirdness 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;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304092 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
