DBD::mysql and mysql_use_result

I want to use the DBD::mysql 'mysql_use_result' attribute to make the
driver use mysql_use_result instead of mysql_store_result, and I want to
do it for all the queries I'm submitting against the database. Having
to set it on each and every statement handle that I generate is a real
pain, I'd like to be able to set the default on the database handle and
have it inherited by all the statement handles that are generated from
the database handle.

I'm not sure of the best way to go about this, there are two options:

1. Store the value in the DBH and copy into the STH when the STH is
created, unless the STD constructor is given an explicit value.

2. Store the value in the DBH and each time the STH is executed, look up
the value in the parent DBH if the STH doesn't have an explicit value.

e.g. given:

$dbh->{mysql_use_result} = 1;
my $sth = $dbh->prepare(...);
$dbh->{mysql_use_result} = 0;

under option 1, when $sth is executed the value of the mysql_use_result
attribute will be 1, and under option 2 it will be 0.

One other question - how do I get the parent DBH from a STH from within
the XS code for a DBD driver?

--
Alan Burlison
--