VInterDev Select Query w/Criteria
Posted on 1997-07-23
I'm issuing a select query from a form handler to look up user id's and password values. If I leave off the criteria, the query works fine, but for some reason, the where statement causes the error.
I'm using the DCC/DTC but I get the same error when I create the query manually.
"SELECT passwords.* FROM passwords WHERE (UserID = " & user & ")"
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected 1.
This is a simple problem but it's driving me crazy. I have several other queries in my application that are structured almost exactly like this one and they work.
Thanks in advance...