I think what you're looking for is @@recordcount that outputs the records affected...
-----Original Message----- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 5:38 PM To: CF-Talk Subject: Stored Procedure recordset. I want to do something in TSQL if results are returned. I forgot the syntax. I think its @@selected but I can't be sure could someone point me in the right direction. Thanks, Neil ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

