Paul
|
Posted: 01/29/2002, 7:23 AM |
|
If i wanted to include an SQL query on Login that decodes a password before processing it, where would i place the code? i want the user to enter the password as normal, but when the login button is pressed the SQL should take that password encode it check it with the encoded password in the DB and then if correct continue as normal.....
|
|
|
Nicole
|
Posted: 01/30/2002, 12:55 AM |
|
Paul,
read CC FAQs: http://www.gotocode.com/art.asp?art_id=22_Toc517639996
and try to search on here on "crypt" keyword. There were some threads on this problem and number of solutions were proposed.
|
|
|
Paul
|
Posted: 01/30/2002, 1:37 AM |
|
Nicole
I can only find information on doing this in PHP and not ASP, all i require is that onEvent an SQL is run saying something like:
select division_country, ammend, approve
from users
where user_name = 'user_name' and encode('password', 'abc') = password;
but i can't see where to add this..... basically the login should encode the password, then check with the password in the database and then take the information 'division_country', 'ammend' and 'approve' values......
|
|
|
Alan C
|
Posted: 01/30/2002, 11:19 AM |
|
Is there a way to encrypt the passwords in the bookstore example using asp and access?
Please help
|
|
|
Chris C
|
Posted: 01/31/2002, 4:51 PM |
|
Help!!!
|
|
|
|