Discussion Locked

Asp Login and Password

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,
my question is about ASP.
I make one database with Access
My table has 3field.
Login ,Password and group.
I make one page ,It give login and password.
If password is correct ...
My question is: When password is correct
I want Give groupof user and send it to another page.
How can I do it ?

Thanks,
M.Alavi

3 replies

by jay eckles

Doesn't sound very difficult...when the user hits the login.asp page, you do a lookup on the table, basically
SELECT * FROM table WHERE LOGIN=Request.Querystring( "Login" )

Then compare the password in the Request to the password from the table...if they match, set a Session variable with the key "Group", then redirect the user. There are alternatives to setting "Group" as a Session variable - you could add the info to the URL, or you could set a cookie, etc. etc.

Good luck.

Jay Eckles
www.jayeckles.com

This discussion is closed to new replies.