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
