Look in DBD::ODBC documentation: This clip is from one of the
DBD::ODBC tests 09multi.t
do {
# print join(":", @{$sth->{NAME}}), "\n";
while ( my $ref = $sth->fetch ) {
# print join(":", @$ref), "\n";
}
$result_sets++;
} while ( $sth->{odbc_more_results} ) ;
Tom
On Thu, Apr 18, 2002 at 01:33:50PM +0400, ������� ����� wrote:
> I use DBD:ODBC with MS SQL Database.
> SQL statement is: 'select a, b, c from mytable compute sum(a), sum(b)'.
> This statement returns two recordsets. When I use 'fetchrow_arrayref',
> it returns only first recordset. How can I retrieve second?
>
> Thanks.
>
> Vasily Popov.
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
