On Mon, 11 Jun 2001 16:39:42 +0200, Bart Lateur wrote:
> print STDERR "$sth->{Statement}\n\t$chap, $pgo, $t1o, $t2o, $tid\n";
> $sth->execute($chap, $pgo, $t1o, $t2o, $tid);
>I get the response back (partly translated into English):
>
>UPDATE HEADINGS SET CHAPTER=?, ORDER_PG=?, ORDER_TYPE_1=?,
>ORDER_TYPE_2=? WHERE ID=?
> 18, 1, 1, 1, 2
>DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access-driver]
>Not enough parameters. The expected count is: 6. (SQL-07001)(DBD:
>st_execute/SQLExecute err=-1)
>
>Huh? 6? I count only 5 question marks... What is going on?
Just as an experiment, I added an extra parameter in the execute call:
$sth->execute($chap, $pgo, $t1o, $t2o, $tid, undef);
Now I get the error message:
execute called with 6 bind variables when 5 are needed
I guess that this is DBI complaining, not the database.
--
Bart.
