I am stumped. I prepare an SQL statement, print it out for checks, and
call it with five parameters. Here's the code and the printout:
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?
--
Bart.
