On a slightly different topic, I noticed yesterday that DBD::mysql
still doesn't have support for multiple statements (and result sets).
There's a patch out there that I applied and that seems to work, but
having also been using DBD::Sybase's multiple return set technique
extensively, I wonder if we shouldn't bake into DBI a framework for
returning multiple result sets.
Right now, the mysql patch that I talked about expects you to know
how many result sets are coming back, and do "while fetchrow..." on
them (or wrap that and trap an error), while DBD::Sybase expects code
like:
do {
while($d = $sth->fetch) {
... do something with the data
}
} while($sth->{syb_more_results});
Would there be a good reason not to request a certain standard
behavior from the multiple DBDs out there that support multiple
statements/result sets?
H