Jim Cromie wrote:
Does this preclude the following ? (as I proposed in 1st message of thread)
$sth->execute( { ":p1" => $foo, ":p2" => $bar } );
Yes. Though it's not hard to do something like this:
$sth->bind_param($_, $params->{$_}) for keys %$param;
$sth->execute;
true enough. but I also wanted ..
@NBVA = ( { pPK => $saved_pk, pFK => $saved_fk },
{ p1 => 1, p2 => 'foo' },
{ seqA => $seqA });for $nbv (reverse @NBVA) {
$sth->bind_param ( $_, $nbv->{$_}) for keys %$nbv;
}
$sth->execute;with the added convenience of not carping about NBVs not applicable to statement,
thus allowing same data to plug into several different statements.
Tim.
.
