|
|
|
|
|
| | |
| |
Active Server Pages ASP a directory of ASP tutorials applications scripts components and articles for the novice to professional developer. CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Parameter Query |
|
From: |
Les Cooper |
|
Date: |
6/9/2000 9:19:19 AM |
|
IP: |
209.212.40.254 |
Ive been getting an error message when using a parameter query with ASP. The SQL String works fine in Access but does not in ASP. A simple query with no parameters works so the database connection is fine.
This is the SQL String:
SELECT tblRecords.[Employee Name], tblRecords.[Training Provider], tblRecords.[Training Description], tblRecords.Date, tblRecords.Duration, tblRecords.[Duration Units]
FROM tblRecords
WHERE (((tblRecords.[Employee Name])=[Employee]));
The error I receive is as follows:
Database Error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Ive tried several differant variations and still recieve the same error. Ive tried to specify the parameter but still the same.
Any Ideas??
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
