|
| |
|
|
Gordon Hay
Posts: 3
From: San Angelo, TX USA
Status: offline
 |
Database Error - FP2000 - 3/10/2001 20:39:00
I am receiving this error on an .ASP page:Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers It is actually one of many continuing problems with my host. Any suggestions?
|
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Database Error - FP2000 - 3/10/2001 14:52:00
Can you post your SQL string?
From memory, I thought it was a permissions thing, but Id like to see the sting first.
| |
|
|
|
Gordon Hay
Posts: 3
From: San Angelo, TX USA
Status: offline
|
RE: Database Error - FP2000 - 3/10/2001 17:53:00
I used the DRW which built this SQL string:SELECT * FROM Results WHERE (Contact_LastName LIKE '%::Contact_LastName::%' AND Contact_FirstName LIKE '%::Contact_FirstName::%') ORDER BY LastName ASC,FirstName ASC
| |
|
|
|
Elecia
Posts: 68
From: orlando
Status: offline
|
RE: Database Error - FP2000 - 3/10/2001 21:37:00
I'm confused is the name of your field contact_lastname or lastname? You are comparing a field named contact_lastname to a variable but you are sorting by a field named lastname. Unless I'm missing something I'd say the field names are wrong in one of the two places that they appear in the string.
EE
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
