Access/ODBC problem

Article View: comp.databases.ms-access

Article #101

Back to comp.databases.ms-access Previous Next

#101

From: Yossi Konijn
Date: Mon, 07 Oct 1996 00:00

24 lines
1396 bytes

Hi,

I've been creating a PERL program that inputs and outputs information
from an Access 7.0 database via ODBC. All my SQL queries worked
perfectly up until the moment I tried using WHERE in the statement.
This gives my an error message about missing parameters. However, the
same query from within Acess works perfectly. Any idea?

The query is -

SELECT * FROM TSCustomers WHERE PhoneNumber1 = "4104842172";

and the error message is:

SQL failed "SELECT * FROM TSCustomers WHERE PhoneNumber1
="4104842172";": [Microsoft][ODBC Microsoft Access 7.0 Driver] Too few
parameters. Expected 1.


Please reply via e-mail since my news server is pretty shaky. Thanks.

Yossi Konijn
yossik@accentsoft.com

Technical Details

Message-ID: <53adhb$5cu@news.NetVision.net.il>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff0ac,2c8a498516eca8d5,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: fa0ae,2c8a498516eca8d5,start
X-Google-Attributes: gidfa0ae,public
X-Google-Thread: 10259a,2c8a498516eca8d5,start
X-Google-Attributes: gid10259a,public
X-Google-Thread: 11355a,2c8a498516eca8d5,start
X-Google-Attributes: gid11355a,public
From: yossik@accentsoft.com (Yossi Konijn)
Subject: Access/ODBC problem
Date: 1996/10/07
Message-ID: <53adhb$5cu@news.NetVision.net.il>
X-Deja-AN: 187278731
organization: NetVision LTD.
newsgroups: comp.databases.ms-access,bit.listserv.sqlinfo,comp.lang.perl,comp.lang.perl.misc