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 statement.
Hi.
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.
**** DISCLAIMER ****
"This e-mail and any attachment thereto may contain information which is confidential
and/or protected by intellectual property rights and are intended for the sole use of
the recipient(s) named above.
Any use of the information contained herein (including, but not limited to, total or
partial reproduction, communication or distribution in any form) by other persons than
the designated recipient(s) is prohibited.
If you have received this e-mail in error, please notify the sender either by
telephone or by e-mail and delete the material from any computer".
Thank you for your cooperation.
For further information about Proximus mobile phone services please see our website at
http://www.proximus.be or refer to any Proximus agent.