Incorrect Syntax near ...

[plasterx]

hey all,i've got this error ...

it said incorrect syntax near the word 'user'. i've tried to print out the sql by doin a response.write and it works. So what could be wrong ??



sql = "SELECT * FROM user where userID = '"&chkUserID&"' and password='"&chkPassword& "'"

[BarrMan]

Is userid a number? if so the query shouldn't have the single quote on the userid.

[Roelf]

i think user is a reserved word, try to use brackets around it: [user]