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
>
>
