Re: How to get several resultsets from SP

2006-05-22 Thread Tom Chiverton
On Friday 19 May 2006 18:00, Adrian Lynch wrote: Conditional logic might change the number. But the definition of a SP is fixed. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited

RE: How to get several resultsets from SP

2006-05-22 Thread Adrian Lynch
:[EMAIL PROTECTED] Sent: 22 May 2006 11:48 To: CF-Talk Subject: Re: How to get several resultsets from SP On Friday 19 May 2006 18:00, Adrian Lynch wrote: Conditional logic might change the number. But the definition of a SP is fixed. -- Tom Chiverton

Re: How to get several resultsets from SP

2006-05-22 Thread Tom Chiverton
On Monday 22 May 2006 12:30, Adrian Lynch wrote: SELECT * FROM Table1 IF @param = 1 SELECT * FROM Table2 SELECT * FROM Table3 In which case 3 result sets are returned, and one of them will be null. 3 sets are always returned because that is how the SP is defined, no ? -- Tom

RE: How to get several resultsets from SP

2006-05-19 Thread Adrian Lynch
Conditional logic might change the number. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 12 May 2006 15:39 To: CF-Talk Subject: RE: How to get several resultsets from SP Surely if it is an SP you will know how many it is returning?! -Original

RE: How to get several resultsets from SP

2006-05-12 Thread Robertson-Ravo, Neil (RX)
Surely if it is an SP you will know how many it is returning?! -Original Message- From: Michel Deloux [mailto:[EMAIL PROTECTED] Sent: 05 May 2006 17:02 To: CF-Talk Subject: How to get several resultsets from SP Hi all I need to know dynamically the number(and metadata) of resultsets

How to get several resultsets from SP

2006-05-05 Thread Michel Deloux
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:

RE: How to get several resultsets from SP

2006-05-05 Thread Dawson, Michael
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