ASP database key query

Hi,

I have a table called login.
Table has a column called key.

On the main html page there is a text box with the name 'key' and has a submit button.

When the user enters a 5 digit key in the text box, he should first be validated as to whether the key matches the one in the database key field or not. If it matches, he should be able to login to the next page success.asp else he should be given a message.. "sorry you entered wrong code".

My database is MS Access.

Can you please helpme.

Thank you.
Nainil Chheda.
URL

This forum isn't for posting requests for projects. We only offer help on issues, if you've shown that you have made at least some effort in learning.

Of course, if you were offering me money for the job, I'd be more than happy to help you out.

There are several articles on the site dealing with logins and asp. Have a look at them - they'll tell you how to do it.

Hi,

I figured out the login thingi..
Thank for your help.. But Can anyone please help me understand what this statement means..

strSQL = "SELECT * FROM login WHERE username = '" & Request.Form("login") & "'"


In my table named login there r 2 fields :
1. login
2. status

What i want is something like select * from login where username = form.login && status = N;

How do i do that?

Please let me know.. i don't know how to write such a statement in ASP.