Thanks for you help,
Marty
--- Tim Bunce <[EMAIL PROTECTED]> wrote:
> On Tue, Sep 14, 2004 at 12:34:09AM +0200, Jenda
> Krynicky wrote:
> > From: Tim Bunce <[EMAIL PROTECTED]>
> > >
> > > Use bind_param() or bind_param_inout() for all
> the params
> > > and then call execute() with no arguments.
> > >
> > > Tim.
> >
> > I wonder ... how about adding a method
> bind_params() like this:
> >
> > sub bind_params {
> > my $sth = shift;
> > my $pos = (ref($_[0]) ? 1 : shift);
> > for my $param (@{$_[0]}) {
> > $sth->bind_param($pos++, $param);
> > }
> > }
>
> No need. See below.
>
> > So that this could be shortened to
> >
> > $sth->bind_params([EMAIL PROTECTED]); # default
> position is 1
> >
>
$sth->bind_param_inout($#execute_args+1,\$new_id,38);
>
> Without adding any new methods it can be shortened
> to
>
> $sth->bind_param($_, $execute_args[$_]) for
> ([EMAIL PROTECTED]);
> $sth->bind_param_inout($#execute_args+1, \$new_id,
> 38);
>
> I'll add that to the docs.
>
> Tim.
>
> p.s. I'd use "scalar @execute_args" or
> "[EMAIL PROTECTED]" instead of "$#execute_args+1".
>
___________________________________________________________ALL-NEW Yahoo! Messenger -
all new features - even more fun! http://uk.messenger.yahoo.com