On Wed, Jan 02, 2002 at 03:07:58PM -0800, Michael Peppler <[EMAIL PROTECTED]> wrote:
> David L. Good writes:
> > On Wed, Jan 02, 2002 at 04:47:43PM -0600, "Accardo, Glen" <[EMAIL PROTECTED]>
>wrote:
> > >
> > >
> > > Many stored procedures (sp_help and sp_depends with SQL Server, for
> > > example) return multiple result sets. The following bit of code
> > > should be the simplest way to print the output of sp_depends. However,
> > > it only prints the first of two result sets. The second result set is
> > > not returned. Looking through the code in ADO.pm, there does not seem
> > > to be support for multiple result sets.
> > >
> > > Is support for multiple result sets planned? Is there a work-around?
> > > How can I get the rest of the stored procedure output?
> >
> > I submitted the patch to add multiple result set support to DBD::ODBC,
> > and I can tell you it gets deep down into the guts of things. I don't
> > know ADO at all or I might take a stab at it, but it is probably not a
> > simple fix. Seems like it ought to be addressed, though. I know that
> > DBD::ODBC was unable to fetch multiple result sets until I patched it.
>
> You guys might want to take a look at DBD::Sybase - as Sybase and
> MS-SQL are essentially the same beast it could be educational
> (although the API is bound to be quite different...)
Indeed. I got most of the ideas for my patch to DBD:ODBC from DBD::Sybase
as well as a fair amount of actual code.
--
David Good [EMAIL PROTECTED]
This space intentionally left blank.
