How do I define the two result sets in the Stored Proc? I am using MS SQL and I can't find anything in their help guide.
-----Original Message----- From: Michael Dinowitz Yes, but you have to use the CFSTOREDPROC and the CFPROCRESULT. Each CFPROCRESULT will have the query name and the order of it's operation from within the stored procedure. <CFSTOREDPROC> <cfprocresult name="query1" resultset="1"> <cfprocresult name="query2" resultset="2"> </CFSTOREDPROC> > Is it possible to return two different queries from a single stored proc? > > Andy Ousterhout > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197627 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
