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:

[WebDNA] Putting '&search' into URL killing all search contexts (2010) Building Calendars (1997) Sendmail truncation in Eudora Clients (1998) Make it Stop - EOM (2006) Re[3]: 2nd WebCatalog2 Feature Request (1996) WebDelivery downloads alias, not original ? (1997) WebCat2.0 acgi vs plugin (1997) a search based on ^(contains) (1998) Another bug to squash (WebCat2b13 Mac .acgi) (1997) [WebDNA] DNA suffix (2008) I think WebDNA-Talk died ... :( (1997) Bug Report, maybe (1997) Pithy questions on webcommerce & siteedit (1997) Looking for 5 to 12 shops with 3 URLs & statements (1997) Server Load Tester (2000) PSC recommends what date format yr 2000??? (1997) WebCatalog Beta Documentation (1997) emailer w/F2 (1997) Nested tags count question (1997) {Comparisons} in [showif] vs. [if] Bug? Inconsistency? (2002)