Hi Janet, you need to use the cfprocresult for multiple result sets. Regards, Andrew Scott http://www.andyscott.id.au/
> -----Original Message----- > From: Janet Whittredge [mailto:[email protected]] > Sent: Thursday, 17 March 2011 8:33 AM > To: cf-newbie > Subject: How to get multiple resultsets from stored procedure > > > 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 > procedure e.g. > <cfstoredproc procedure="getDataExport" datasource="#DS#"> > <cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" dbvarname="syear" > value= "#Arguments.sYear#" null="No"> > <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" > dbvarname="sComm" value="#Arguments.sComm#" null="Yes"> > <cfprocresult name="qExport.resultset.i1" resultset="1"> <cfprocresult > name="qExport.resultset.i2" resultset="2"> <cfprocresult > name="qExport.resultset.i3" resultset="3"> </cfstoredproc> > > I get only the first resultset back. Is there some Cold Fusion configuration or > SQL Server configuration required to get this to work? I tried adding the > "allowMultiQueries=true" in the connection string for the datasource. > I don't want to re-write this procedure. Advise, please. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > ~~~~~~~~~~~| > 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:5235 > 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:5236 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
