But don't you have an invalid count? 3 parameters in the SQL (3 question marks)
and onlt 2 bound parameters (two calls to bind_param for params 1 and 2).
Martin
On 18-Sep-2002 Ulrike Schmidt wrote:
> Hello,
>
> I have a similar problem to Brad some days ago, but the solution that
> worked for him leads to new error messages for me. I am trying to insert
> values into an Access database, "conc_name" and "definition" are of type
> "Memo". The error message I get is:
>
> [Microsoft][ODBC Microsoft Access Driver]COUNT-Feld ungültig.
> (SQL-07001)(DBD: st_execute/SQLExecute err=-1) at PerlModule/Database.pm
> line 110.
>
> Here an excerpt of my code with the possibly relevant information:
>
> use DBI qw(:sql_types);
> my $dbh = DBI->connect("DBI:ODBC:MLTD",
> {
> 'RaiseError' => 1,
> 'LongReadLen' => 2048,
> 'LongTruncOk' => 1
> }
> );
>
> my $sql .= "INSERT INTO tbl_concepts_wn
> (conc_name,definition,source) VALUES (?,?,?)";
> my $sth = $dbh->prepare($sql);
> $sth->bind_param(1, $conc_name, SQL_LONGVARCHAR);
> $sth->bind_param(2, $definition, SQL_LONGVARCHAR);
> $sth->execute or die $dbh->errstr;
>
> I also tried the following variation:
>
> $sth->bind_param(1, $conc_name, DBI::SQL_LONGVARCHAR);
> $sth->bind_param(2, $definition, DBI::SQL_LONGVARCHAR);
>
> What could I be doing wrong?
>
> TIA, Uli
--
Martin J. Evans
Easysoft Ltd, UK
Development
