working with multiple result set
| From: | Syunya Yamanaka@bijoux | Date: | Fri, 21 Mar 2003 19:58:17 +0000 |
| Subject: | working with multiple result set | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-4365@lists.php.net to get a copy of this message | ||
Hi all.
At this time,I want to know how to work with multiple result set with
PEAR.
I have following simple query that returns two result set at once.
select * from t_A;
select * from t_B;
In script file,I did following.
require_once('DB.php');
$dsn = "pgsql://userA:mypasswd@localhost:5432t/mydb";
$db = DB::connect($dsn, true);
$query = "select * from t_A;\n";
$query .= "select * from t_B";
$rs = $db->query($query);
I expect that $rs will hold multiple result set and prepared function to
work around them.
But I could work with single result set that hold result set that
executed by last "select" statement.
Under ADO interface,result set object will hold multiple result set
automatically and we can use NextRecordset function against result set
object(with Microsoft ASP environment).
Any idea?
Thank you very much.