Nope one record set. It just seems strange that <cfquery>exec myStoredProc</cfquery> and <cfstoredproc procedure="myStoredProc"></cfstoredproc> (a lot left out for brevity) don't return the same record set.
Steve -----Original Message----- From: Judah McAuley [mailto:ju...@wiredotter.com] Sent: Wednesday, November 30, 2011 2:28 PM To: cf-talk Subject: Re: Weird SQL Query happenings... Is it returning multiple recordsets perhaps? Or possibly returning a cursor to the recordset? Judah ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348914 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm