Oops, yes, now everything works fine, thanks a lot! (embarassing ...) Uli
[EMAIL PROTECTED] wrote: >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 > >