Tim Bunce wrote: > ----- Forwarded message from Yuriy Tretyakov <tretyakof...@ukr.net> ----- > > To: tim.bu...@pobox.com > From: Yuriy Tretyakov <tretyakof...@ukr.net> > Date: Tue, 15 Sep 2009 12:31:05 +0300 > > Hello Tim. > > I have a very important task, but I'm stopped now because failed to solve > one problem. > > I working with MS SQL DB using DBI module. Stored procedure that I'm > executing returns two recordset: > first -with only one column > second -with 3 columns. > I need second column in second recordset. Is there ability in DBI module > to access it? Or maybe any > other way to get second recordset? > > Thanks in advance! > > ----- End forwarded message ----- > > If you are using DBD::ODBC, then look at calling more_results and look at the test code in t/ dir for examples.
Each subsequent "recordset" created by a procedure is available after more_results is called. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com