|
 |
asp_databases thread: ADO Recordsets and Stored Procedures
Message #1 by "Eduardo Bezerra" <edubez@v...> on Fri, 20 Apr 2001 16:49:13 -0300
|
|
How can I retrieve the recordset from a Stored
Procedure when the same contains more than
one SELECT statement ?
Regards,
Eduardo
Eduardo Bezerra
e-mail: edubez@v...
--
VisualNet - O seu Provedor Internet
http://www.visualnet.com.br/
Message #2 by "Charles Feduke" <webmaster@r...> on Fri, 20 Apr 2001 18:00:52 -0400
|
|
If you return more than one recordset, try Recordset.NextRecordset to
move to the next recordset...
rsRecordset = rsRecordset.NextRecordset ' returns a recordset object, the
next in a series
- Chuck
----- Original Message -----
From: "Eduardo Bezerra" <edubez@v...>
To: "ASP Databases" <asp_databases@p...>
Sent: Friday, April 20, 2001 3:49 PM
Subject: [asp_databases] ADO Recordsets and Stored Procedures
> How can I retrieve the recordset from a Stored
> Procedure when the same contains more than
> one SELECT statement ?
>
> Regards,
> Eduardo
>
> Eduardo Bezerra
> e-mail: edubez@v...
>
>
> --
> VisualNet - O seu Provedor Internet
> http://www.visualnet.com.br/
>
>
Message #3 by "Tomm Matthis" <matthis@b...> on Sat, 21 Apr 2001 10:43:49 -0400
|
|
Look at the rs.NextRecordset method.
Tomm
> -----Original Message-----
> From: Eduardo Bezerra [mailto:edubez@v...]
> Sent: Friday, April 20, 2001 3:49 PM
> To: ASP Databases
> Subject: [asp_databases] ADO Recordsets and Stored Procedures
>
>
> How can I retrieve the recordset from a Stored
> Procedure when the same contains more than
> one SELECT statement ?
>
> Regards,
> Eduardo
>
> Eduardo Bezerra
> e-mail: edubez@v...
>
>
> --
> VisualNet - O seu Provedor Internet
> http://www.visualnet.com.br/
>
>
Message #4 by "Eduardo Bezerra" <edubez@v...> on Mon, 23 Apr 2001 09:40:51 -0300
|
|
Hi Tomm,
Thank you very, very much.
You saved my day. This problem haunts me for
about an year. I posted this before but no one
could help me at the time.
Best regards,
Eduardo
> Look at the rs.NextRecordset method.
>
> Tomm
>
> > -----Original Message-----
> > From: Eduardo Bezerra [mailto:edubez@v...]
> > Sent: Friday, April 20, 2001 3:49 PM
> > To: ASP Databases
> > Subject: [asp_databases] ADO Recordsets and Stored Procedures
> >
> >
> > How can I retrieve the recordset from a Stored
> > Procedure when the same contains more than
> > one SELECT statement ?
> >
> > Regards,
> > Eduardo
> >
> > Eduardo Bezerra
> > e-mail: edubez@v...
> >
> >
> > --
> > VisualNet - O seu Provedor Internet
> > http://www.visualnet.com.br/
> >
> >
>
Eduardo Bezerra
e-mail: edubez@v...
--
VisualNet - O seu Provedor Internet
http://www.visualnet.com.br/
Message #5 by "Tomm Matthis" <matthis@b...> on Mon, 23 Apr 2001 09:18:56 -0400
|
|
No problem Eduardo.... I know how frustrating it can be.
Tomm
> -----Original Message-----
> From: Eduardo Bezerra [mailto:edubez@v...]
> Sent: Monday, April 23, 2001 8:41 AM
> To: ASP Databases
> Subject: [asp_databases] RE: ADO Recordsets and Stored Procedures
>
>
> Hi Tomm,
>
> Thank you very, very much.
>
> You saved my day. This problem haunts me for
> about an year. I posted this before but no one
> could help me at the time.
>
> Best regards,
> Eduardo
>
> > Look at the rs.NextRecordset method.
> >
> > Tomm
> >
> > > -----Original Message-----
> > > From: Eduardo Bezerra [mailto:edubez@v...]
> > > Sent: Friday, April 20, 2001 3:49 PM
> > > To: ASP Databases
> > > Subject: [asp_databases] ADO Recordsets and Stored Procedures
> > >
> > >
> > > How can I retrieve the recordset from a Stored
> > > Procedure when the same contains more than
> > > one SELECT statement ?
> > >
> > > Regards,
> > > Eduardo
> > >
> > > Eduardo Bezerra
> > > e-mail: edubez@v...
> > >
> > >
> > > --
> > > VisualNet - O seu Provedor Internet
> > > http://www.visualnet.com.br/
> > >
> > >
> >
>
> Eduardo Bezerra
> e-mail: edubez@v...
>
>
> --
> VisualNet - O seu Provedor Internet
> http://www.visualnet.com.br/
>
>
|
|
|
View Cart
