Ok I didn't see them in the code, the following like is what I used. Which appears to be what you are doing.
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_p-q_1 5.html Regards, Andrew Scott http://www.andyscott.id.au/ > -----Original Message----- > From: Janet Whittredge [mailto:[email protected]] > Sent: Thursday, 17 March 2011 8:43 AM > To: cf-newbie > Subject: Re: How to get multiple resultsets from stored procedure > > > I am using it - see example. I have three cfprocresults for the three expected > result sets. Can you send example? > > Thank you, > Janet > > >Hi Janet, you need to use the cfprocresult for multiple result sets. > > > >Regards, > >Andrew Scott > >http://www.andyscott.id.au/ > > > > > > > >> I run Coldfusion8 and MS SQL 2008 on Server2003. > >> > >> I have an CF app that calls a stored procedure. The procedure > >> generates several resultsets. I see the result sets in Studio, but > >> when I call the > >stored > >configuration or > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > ~~~~~~~~~~~| > Order the Adobe Coldfusion Anthology now! > http://www.amazon.com/Adobe-Coldfusion- > Anthology/dp/1430272155/?tag=houseoffusion > Archive: http://www.houseoffusion.com/groups/cf- > newbie/message.cfm/messageid:5237 > Subscription: http://www.houseoffusion.com/groups/cf- > newbie/subscribe.cfm > Unsubscribe: http://www.houseoffusion.com/groups/cf- > newbie/unsubscribe.cfm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5238 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
