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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2257 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
