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 Ch
:[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 Chiver
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 liabilit
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
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
, 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
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: ht
7 matches
Mail list logo