You have to provide a fixed number of storedproc results tags. If you are unsure how many result sets may be returned from your stored proc, then estimate the highest number and create that many storedproc result tags.
Let's say you may have up to 20 result sets. If you specify 20 result sets, but your stored proc returns only three results sets, CF will not throw an error. However, you will need to "test" your result sets to ensure they were populated before using them. M!ke -----Original Message----- From: Michel Deloux [mailto:[EMAIL PROTECTED] Sent: Friday, May 05, 2006 11:02 AM To: CF-Talk Subject: How to get several resultsets from SP Hi all I need to know dynamically the number(and metadata) of resultsets returned after executing a Stored Procedure. I'm using CF MX 6 and SQL Server. With CF I can do that? Any tips? Factory methods? Cheers MD ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239682 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
