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

Reply via email to