On Fri, Feb 01, 2002 at 11:21:49AM -0500, Rick Windham - ISDLIS wrote:

> my $sql = qq{ insert into apache_load_test(host,ident,authuser,http_date) values (?, 
>?, ?,
> to_date(?,'dd/mon
> /yyyy:hh:mi:ss')) };
> my $sth = $dbh->prepare ( $sql );

>         $sth->execute($values[0], $values[1], $values[2]), $values[3]|| die ("didn't 
>insert
> $dbh->errstr\n")
> ;
>         $dbh->commit;
> 
> I receive this error:
> 
> execute called with 3 bind variables when 4 are needed at apache_slice_up.pl line 
>25, <EP> line 1.

This error is completely accurate.  You have called execute with three bind
values instead of four.  Try putting $values[3] *inside* the parentheses.

Ronald

Reply via email to