Re: logging in a user

This WebDNA talk-list message is from

1999

It keeps the original formatting. numero = 22335
interpreted = N
texte = In my typical style i no sooner post a question than i answer it myself. i call this process expose thyself and the answers shall come?? now where did that come from??the solution i came up with: [ShowIf [LookUp db=BldrUsers.db&value=[Uppercase][AUserName_][/Uppercase]&lookinfield=UserName&returnfield=PassWord¬found=]=[Encrypt][APassWord_][/Encrypt]]OK this to works [/ShowIf]>I am creating my first user login pages for a site that has a members >only section. Here is the logic I am trying to use, but it is not quite >working.>>The user chooses a name and password. hits submit.>The next page checks to see if it already exists as a user name:>> [ShowIf [Lookup >db=BldrUsers.db&value=[Uppercase][UserName_][/Uppercase]&lookinfield=UserNa>me&ReturnField=UserName&NotFound=]=[Uppercase][UserName_][/Uppercase]]> This User Name [UserName_] Already Exists. Please Try Another!> [/ShowIf]>

> [ShowIf [Lookup >db=BldrUsers.db&value=[Uppercase][UserName_][/Uppercase]&lookinfield=UserNa>me&ReturnField=UserName&NotFound=]![Uppercase][UserName_][/Uppercase]]> [Append >db=BldrUsers.db]UserName=[Uppercase][UserName_][/Uppercase]&PassWord=[Encry>pt][PassWord_][/Encrypt]&EmailAddr=[EmailAddr_][/Append]> User [UserName_] Added.>>>This bit above works fine (thanks ken)>>If they choose a unique name then>At this point I let them go to the login page>On this page I do another lookup to see if the name and passord are a >match. this part is >*not* working. here is what I have:>>> [ShowIf [LookUp >db=BldrUsers.db&value=[Uppercase][AUserName_][/Uppercase]&lookinfield=UserN>ame&returnfield=UserName¬found=]=[Uppercase][AUserName_][/UpperCase][/Lo>okUp]first showif ok> [ShowIf [LookUp >db=BldrUsers.db&value=[Encrypt][APassWord_][/Encrypt]&lookinfield=PassWord&>returnfield=PassWord¬found=]=[Encrypt][AUserName_][/Encrypt][/LookUp][/S>howIf]You got in[/ShowIf]>>>What is up? Am I missing something? How are others doing this type of >stuff? I would love any suggestions.>>Thanks.>>>-->_______________________________________________________________>Charles Kline ckline@macsultants.com > >WebMaster - eCommerce Specialist>>>MacSultants>Professional Solutions for Computer Systems>>Phone# 609-273-3255>Fax# 609-273-3721>>>>--_______________________________________________________________Charles Kline ckline@macsultants.com  WebMaster - eCommerce SpecialistMacSultantsProfessional Solutions for Computer SystemsPhone# 609-273-3255Fax# 609-273-3721 Associated Messages, from the most recent to the oldest:

Re: logging in a user (charles kline 1999) logging in a user (charles kline 1999)

In my typical style i no sooner post a question than i answer it myself. i call this process expose thyself and the answers shall come?? now where did that come from??the solution i came up with: [ShowIf [LookUp db=BldrUsers.db&value=[uppercase][AUserName_][/Uppercase]&lookinfield=UserName&returnfield=PassWord¬found=]=[encrypt][APassWord_][/Encrypt]]OK this to works [/ShowIf]>I am creating my first user login pages for a site that has a members >only section. Here is the logic I am trying to use, but it is not quite >working.>>The user chooses a name and password. hits submit.>The next page checks to see if it already exists as a user name:>> [ShowIf [Lookup >db=BldrUsers.db&value=[uppercase][UserName_][/Uppercase]&lookinfield=UserNa>me&ReturnField=UserName&NotFound=]=[uppercase][UserName_][/Uppercase]]> This User Name [UserName_] Already Exists. Please Try Another!> [/ShowIf]>

> [ShowIf [Lookup >db=BldrUsers.db&value=[uppercase][UserName_][/Uppercase]&lookinfield=UserNa>me&ReturnField=UserName&NotFound=]![uppercase][UserName_][/Uppercase]]> [Append >db=BldrUsers.db]UserName=[uppercase][UserName_][/Uppercase]&PassWord=[Encry>pt][PassWord_][/Encrypt]&EmailAddr=[EmailAddr_][/Append]> User [UserName_] Added.>>>This bit above works fine (thanks ken)>>If they choose a unique name then>At this point I let them go to the login page>On this page I do another lookup to see if the name and passord are a >match. this part is >*not* working. here is what I have:>>> [ShowIf [LookUp >db=BldrUsers.db&value=[uppercase][AUserName_][/Uppercase]&lookinfield=UserN>ame&returnfield=UserName¬found=]=[uppercase][AUserName_][/UpperCase][/Lo>okUp]first showif ok> [ShowIf [LookUp >db=BldrUsers.db&value=[encrypt][APassWord_][/Encrypt]&lookinfield=PassWord&>returnfield=PassWord¬found=]=[encrypt][AUserName_][/Encrypt][/LookUp][/S>howIf]You got in[/ShowIf]>>>What is up? Am I missing something? How are others doing this type of >stuff? I would love any suggestions.>>Thanks.>>>-->_______________________________________________________________>Charles Kline ckline@macsultants.com > >WebMaster - eCommerce Specialist>>>MacSultants>Professional Solutions for Computer Systems>>Phone# 609-273-3255>Fax# 609-273-3721>>>>--_______________________________________________________________Charles Kline ckline@macsultants.com  WebMaster - eCommerce SpecialistMacSultantsProfessional Solutions for Computer SystemsPhone# 609-273-3255Fax# 609-273-3721 charles kline

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:

test (2002) PIXO (1997) Problem 2: Prefs file... (1997) Tracking inbound links for discounts (1997) [OT] Mac Utility Required (2000) Replace context problem ... (1997) WebCat and image maps (1997) [WebDNA] V8.6 FCGI (2018) Multiple Newcarts (1996) WebCatalog/Mac 2.1b2 New Features (1997) PCS Frames (1997) Multiple catalog databases and showcart (1997) Cart Numbers (1997) Cart Question: The Epic Saga (1998) Mozilla/4. and Browser Info.txt (1997) Make sure I understand this??? (1997) TCPConnect / Current Temperature (2004) Search in 2 or more catalogs (1997) Image upload (2000) WebCat cannot handle compatible search parameters? (1997)