On Thu, Jan 31, 2002 at 04:32:49PM -0500, [EMAIL PROTECTED] wrote:
> When calling the selectrow_array method with a list of bind values 1) do I
> need to include an attribute hash reference? 2) If I do, how do I associate
> the different SQL types to the list of bind value? Any example would be
> appreciated.
You can't (currently, and I've no plans to change it soon).
The nearest would be
$sth = $dbh->prepare(...)
$sth->bind_param(1, "dummy", { TYPE =>... });
$sth->bind_param(2, "dummy", { TYPE =>... });
$sth->bind_param(3, "dummy", { TYPE =>... });
... later, possibly inside a loop ...
@row = $dbh->selectrow_array($sth, undef, @bind_values);
That works, or should if your driver was written correctly, because
a) the DBI says that the TYPE of a placeholder is 'sticky'
b) you can pass selectrow_array an $sth instead of a sql statement
Tim.
