Getting Multiple Recordsets from an SP

[Wayne Wengert]

I am using ASP 3.0/ADO to call an SP. The SP has multiple SELECT statements
so I
need to get the multiple return sets but I cannot find the right syntax. I
searched BOL and Google but cannot find an example that applies. Some
articles imply to use GetNextResult while others suggest GetNextRS.

I use set myRS = myConn.execute("EXEC " & strTemp) to call the SP. What is
the correct syntax to get the next resultset?

Wayne

[Ray at]

Here's an example:
[url]http://www.devguru.com/Technologies/ado/quickref/recordset_nextrecordset.html[/url]

Ray at work

"Wayne Wengert" <wayneDONTWANTSPAM@wengert.com> wrote in message
news:%23YiF%23guoDHA.2868@TK2MSFTNGP09.phx.gbl...

> I am using ASP 3.0/ADO to call an SP. The SP has multiple SELECT

statements

> so I
> need to get the multiple return sets but I cannot find the right syntax. I
> searched BOL and Google but cannot find an example that applies. Some
> articles imply to use GetNextResult while others suggest GetNextRS.
>
> I use set myRS = myConn.execute("EXEC " & strTemp) to call the SP. What

is

> the correct syntax to get the next resultset?
>
> Wayne
>
>

[Wayne Wengert]

Thanks Ray - that is what I needed. It works fine now.

Wayne


"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:ORqKTkuoDHA.2584@TK2MSFTNGP09.phx.gbl...

> Here's an example:
>

[url]http://www.devguru.com/Technologies/ado/quickref/recordset_nextrecordset.html[/url]

>
> Ray at work
>
> "Wayne Wengert" <wayneDONTWANTSPAM@wengert.com> wrote in message
> news:%23YiF%23guoDHA.2868@TK2MSFTNGP09.phx.gbl...

> > I am using ASP 3.0/ADO to call an SP. The SP has multiple SELECT

> statements

> > so I
> > need to get the multiple return sets but I cannot find the right syntax.

I

> > searched BOL and Google but cannot find an example that applies. Some
> > articles imply to use GetNextResult while others suggest GetNextRS.
> >
> > I use set myRS = myConn.execute("EXEC " & strTemp) to call the SP. What

> is

> > the correct syntax to get the next resultset?
> >
> > Wayne
> >
> >

>
>

[Aaron Bertrand - MVP]

[url]www.aspfaq.com/2201[/url]



"Wayne Wengert" <wayneDONTWANTSPAM@wengert.com> wrote in message
news:#YiF#guoDHA.2868@TK2MSFTNGP09.phx.gbl...

> I am using ASP 3.0/ADO to call an SP. The SP has multiple SELECT

statements

> so I
> need to get the multiple return sets but I cannot find the right syntax. I
> searched BOL and Google but cannot find an example that applies. Some
> articles imply to use GetNextResult while others suggest GetNextRS.
>
> I use set myRS = myConn.execute("EXEC " & strTemp) to call the SP. What

is

> the correct syntax to get the next resultset?
>
> Wayne
>
>