I insert data into tables and then use ident_current without using the NOCOUNT option and all works fine. I don't think that NOCOUNT is required when doing multiple queries.
Ray Thompson Tau Beta Pi (www.tbp.org) The Engineering Honor Society 865-546-4578 -----Original Message----- From: Michael Kear [mailto:[EMAIL PROTECTED] Sent: Friday, April 29, 2005 7:44 PM To: SQL Subject: RE: set nocount on? Don't know Bryan - give it a try and see what happens. All I know is that the nocount turns off the message back from the sqlserver so you can have both the insert statement and the ident_current statement in the same cfquery. I don't have time to try the looping insert now .. how about you let us know what happens when you try it. Cheers Mike Kear Windsor, NSW, Australia Macromedia Certified Advanced ColdFusion Developer http://afpwebworks.com ...com, .net, .org etc domains start at A$20 / year Full scale ColdfusionMX hosting from $15/month. -----Original Message----- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Saturday, 30 April 2005 7:29 AM To: SQL Subject: Re: set nocount on? > Its purpose in the CFQUERY is to turn off the SQLServer's responses which > would halt the query. You need to do that if you are going to have more > than one SQL operation in one CFQUERY. You sure Mike?? try running this kind of cfquery in MS SQL <cfquery.....> <cfloop from=1 to="5" index="i"> INSERT INTO blah; </cfloop> </cfquery> That's 5 SQL operations in 1 CFQUERY...and it will run...or am I misunderstanding you? Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2261 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
