
December 22nd, 2008, 11:27 AM
|
|
Registered User
|
|
Join Date: Dec 2008
Posts: 4
Time spent in forums: 31 sec
Reputation Power: 0
|
|
|
Create query design HELP!
Hey ppl in my database i have this
UserID = autonumber
UserNric = text
when i try to put this coding SELECT * FROM User WHERE userID = 1; , it can actually dispaly all my user particulars for the id
but when i try to do the other way round for this coding SELECT * FROM User WHERE userNric = (example which is in the database) S123141G; it prompt an error, any idea how to do the nric part i need it for my project thanks alot for those reading(:
i need it for my project in the entity class to retrieve the code
String dbQuery = "SELECT * FROM User WHERE userNric =" + nric;
apparently it cant. The error is [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
|