On Thu, 18 Apr 2002 13:33:50 +0400
[EMAIL PROTECTED] wrote:
This statement returns two recordsets. When I use 'fetchrow_arrayref',
it returns only first recordset. How can I retrieve second?
Fetchrow fetches, well - as it names says, just one row.
Call it as many time, as many rows is
While( $array_ref = $sth-fetchrow_arrayref() ) {
#recordset treatement here ...
}
José.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 11:34 AM
To: [EMAIL PROTECTED]
Subject: How to retrieve multiply recordsets returned by
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} ) ;
Read the DBD::ODBC pod regarding the attribute odbc_more_results and also
see t\09multi.t for examples.
Jeff
-Original Message-
From: ÷ÁÓÉÌÉÊ ðÏÐÏ× [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 5:34 AM
To: [EMAIL PROTECTED]
Subject: How to retrieve multiply recordsets