SQL statement for JSP

[piertiong]

What's wrong with this statement?

INSERT INTO customer(userId,password,email,fname,lname,gender,mStatus,language,country,state,city,zipcode,addres s,occupation,income,contact,nric,dob)
Values
(userid,pw,email,fname,lname,gender,mstatus,language,country,state,city,zipcode,address,occupation,i ncomerange,contact,nricno,('250584'))

[Nicodemas]

I believe 'password' is a keyword in MS Access and most other DBMSs. Encapsulate it with '[' and ']'

[piertiong]

Originally posted by Nicodemas
I believe 'password' is a keyword in MS Access and most other DBMSs. Encapsulate it with '[' and ']'

have changed it to pw, doesn't work. tomcat says general error and i can't find it. is it possible for me to send the .jsp file to you?