On Mon, Oct 27, 2003 at 10:10:12AM -0800, Dean Arnold wrote: > Tim Bunce wrote: > > > > No. The only thing I'd be happy with is what DBD::Oracle does. > > Use implicit placeholder names for the value so > > > > $sth->execute($foo, $bar); > > > > is the same as > > > > $sth->bind_param(":p1", $foo) > > $sth->bind_param(":p2", $bar) > > $sth->execute(); > > Explicit binding in this case is OK by me...is there any collision here with > the on-going row-wise vs. column-wise array binding thread ?
I don't see why there would be any, but I can't remember the details of that thread at the momement :) > 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; Tim.