What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

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:

prefs file not being written to (2000) Execute Applescript (1997) [WebDNA] encrypt files/directories (2011) Suffix Mapping (1997) (OT) Support system (2000) Bug alert! (1997) [WebDNA] Need to get off! (2008) Can't get appendfile to work (1997) [WebDNA] MacOS 10.5 instal/config. I'm drowning. ...just needs to work for LOCAL one person (2008) RAM variables (1997) ImageMap (1997) Soft return (2001) Problem 2: Prefs file... (1997) WebCat2 - Getting to the browser's username/password data (1997) restart needed???? (1997) Re: (1997) Associative lookup style? + bit more (1997) [WebDNA] naming math vars in v.7 (2010) Grouping Fields in Context (1999) Cancel Subscription (1996)