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
]
erfurt.de cc:
Subject: RE: Quirky problem with
DBI
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
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
Brad,
What version of DBD::ODBC are you using? If you are using DBD::ODBC 0.28
from ActiveState, then I suggest upgrading to the latest (which has a PPM
file at ftp://ftp.esoftmatic.com/pub/outgoing/DBI
Please upgrade your DBI too, as you must use the version I have uploaded
there.
Regards,
Yes, access is sometimes quirky about longs/memos. Try doing this (in
pseudo code) (warning, may wrap long lines):
#!perl -w
# above line makes sure perl is running with warnings.
use strict; # make sure we have strict on to check for dumb typos
use DBI
for you.
Jeff
-Original Message-
From: Brad Smith [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 09, 2002 8:14 PM
To: Jeff Urlwin
Subject: RE: Quirky problem with DBI
Jeff:
Still, no luck. I have altered the code (below), but it fails with the
following error. PArdon my