I found it. There is a configuration setting on the datasource for SQL Server which enables multiple resultsets. In the Advanced Settings enter MultipleActiveResultSets=true in the Connection String
>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/ > > > > > >> I am using it - see example. I have three cfprocresults for the three >expected ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:5241 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
