Re: User Authentication

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 54531
interpreted = N
texte = Don't forget that LOOKUP is case sensitive :) On Friday, November 28, 2003, at 01:11 AM, Alan White wrote: > Hi Folks... > > Can anyone help me debug this or let me know if I am going down the > right > track for creating a user authentication system. At the moment it just > seems to be executing the final else statement. > > Thanks in advance... > > Alan > > P.S. Comments are heavy so you know what I am trying to do.... > > [!] > > Description > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > The idea is that when the user logs in the following will take place:- > > 1) Enter login details > 2) Check username is valid otherwise display error1 > 3) If the username is valid, check the password against it. > 4) If the username and password are valid then check which level of > access > is allowed and redirect to content. > 5) Display error2 if the username and password do not match. > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > [/!] > > [!] > > Example of database format > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > ------------------------------------------------------- > userID userName password accessLevel > ------------------------------------------------------- > 1 alan freak 1 > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > [/!] > > > [!] > > Variables being passed > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > _userName // Username from login > _password // Password from login > > error1 & 2 // Used to display the following messages on index page > > error1 : Username has not been recognised please re-enter > > error2 : There is a problem with your password please re-enter it > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > [/!] > > [!] > > The Code > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > [/!] > > [text]checkName=[lookup > db=admin/ > users.db&value=[_userName]&lookinfield=userName&returnfield=userNam > e][/text] > [if "[_userName]"="[checkName]"] > [then] > [text]checkPass=[lookup > db=admin/ > users.db&value=[_userName]&lookinfield=userName&returnfield=passwor > d][/text] > [if ("[_userName]"="[checkName]") & ("[_password]"="[checkPass]") > [then] > [lookup > db=admin/ > users.db&value=[_userName]&lookinfield=userName&returnfield=accessL > evel] > [redirect > url=https://www.hanon-shop.com/press/ > press.html?accessLevel=[accessLevel]] > [/then] > [else] > [redirect > url=https://www.hanon-shop.com/press/index.html?error=2] > [/else] > [/if] > [redirect url=https://www.hanon-shop.com/press/press.html] > [/then] > [else] > [redirect url=https://www.hanon-shop.com/press/index.html?error=1] > [/else] > [/if] > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > > Regards Stuart Tremain idfk web developments 114a/40 yeo street neutral bay 2089 australia t +612 9908 2134 f +612 9908 4837 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: user authentication via TCPSend ( Terry Wilson 2005)
  2. Re: user authentication via TCPSend ( John Peacock 2005)
  3. user authentication via TCPSend ( Terry Wilson 2005)
  4. Re: User Authentication ( Stuart Tremain 2003)
  5. Re: User Authentication ( Gary Krockover 2003)
  6. Re: wierd... [Was] User Authentication ( Alan White 2003)
  7. wierd... [Was] User Authentication ( Alan White 2003)
  8. Re: User Authentication ( Alan White 2003)
  9. Re: User Authentication ( Alan White 2003)
  10. Re: User Authentication ( Gary Krockover 2003)
  11. Re: User Authentication ( Alex McCombie 2003)
  12. Re: User Authentication ( Alex McCombie 2003)
  13. Re: User Authentication ( Andy Mowrey 2003)
  14. Re: User Authentication ( Alex McCombie 2003)
  15. Re: User Authentication ( Alan White 2003)
  16. Re: User Authentication ( Alex McCombie 2003)
  17. User Authentication ( Alan White 2003)
Don't forget that LOOKUP is case sensitive :) On Friday, November 28, 2003, at 01:11 AM, Alan White wrote: > Hi Folks... > > Can anyone help me debug this or let me know if I am going down the > right > track for creating a user authentication system. At the moment it just > seems to be executing the final else statement. > > Thanks in advance... > > Alan > > P.S. Comments are heavy so you know what I am trying to do.... > > [!] > > Description > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > The idea is that when the user logs in the following will take place:- > > 1) Enter login details > 2) Check username is valid otherwise display error1 > 3) If the username is valid, check the password against it. > 4) If the username and password are valid then check which level of > access > is allowed and redirect to content. > 5) Display error2 if the username and password do not match. > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > [/!] > > [!] > > Example of Database format > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > ------------------------------------------------------- > userID userName password accessLevel > ------------------------------------------------------- > 1 alan freak 1 > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > [/!] > > > [!] > > Variables being passed > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > _userName // Username from login > _password // Password from login > > error1 & 2 // Used to display the following messages on index page > > error1 : Username has not been recognised please re-enter > > error2 : There is a problem with your password please re-enter it > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > [/!] > > [!] > > The Code > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > [/!] > > [text]checkName=[lookup > db=admin/ > users.db&value=[_userName]&lookinfield=userName&returnfield=userNam > e][/text] > [if "[_userName]"="[checkName]"] > [then] > [text]checkPass=[lookup > db=admin/ > users.db&value=[_userName]&lookinfield=userName&returnfield=passwor > d][/text] > [if ("[_userName]"="[checkName]") & ("[_password]"="[checkPass]") > [then] > [lookup > db=admin/ > users.db&value=[_userName]&lookinfield=userName&returnfield=accessL > evel] > [redirect > url=https://www.hanon-shop.com/press/ > press.html?accessLevel=[accessLevel]] > [/then] > [else] > [redirect > url=https://www.hanon-shop.com/press/index.html?error=2] > [/else] > [/if] > [redirect url=https://www.hanon-shop.com/press/press.html] > [/then] > [else] > [redirect url=https://www.hanon-shop.com/press/index.html?error=1] > [/else] > [/if] > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > > Regards Stuart Tremain idfk web developments 114a/40 yeo street neutral bay 2089 australia t +612 9908 2134 f +612 9908 4837 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Stuart Tremain

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

SKU Question (1999) OT: Backup Strategies (2007) One Hour Email (2002) OT: Amazon Patents (2000) What date is it anyway? (2004) JavaScript (1998) [WebDNA] User sessions - cookies only or cookies and a sessions.db? (2016) missing records (1998) reading a email (2000) http upload (2001) [ConvertChars] problem (1997) (2000) FEW QUESTIONS (1997) Sample Tea Room Search Error (1997) [ListFiles] & [loop] (1998) Follow-up to listfiles bug report ... (2003) Disappearing HTML/WebDNA (1998) PCS Frames (1997) WCS Newbie question (1997) Loosing Quantity (2000)