Hi all,

i am new to java servlets. i simply created a login form with username and password fields. now when i deployed it on tomcat server, after i click on submit button it gives the following error:

java.sql.SQLException: Column not found

codin of this login servlet is attached below. i have used username,password,name and address fields in my table(database). i have created it using ms-access.
please reply asap!!!

Hi ankiwalia and welcome to Daniweb

Your SQL syntax is incorrect. Instead of this:
Try this:

thank you darkagn..that was really a help...i changed the syntax..and it worked fine!!!