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