> Just as an experiment, I added an extra parameter in the execute call:
As an additional experiment, try using DBD::ADO instead of DBD::ODBC.
Sometimes Access stored queries require a parameter that DBI doesn't
know about.
Tom
On Mon, Jun 11, 2001 at 05:45:22PM +0200, Bart Lateur wrote:
> 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.
>
--
Thomas A. Lowery
See DBI/FAQ http://tlowery.hypermart.net
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
