Re: Missing something simple?

This WebDNA talk-list message is from

1999

It keeps the original formatting. numero = 22317
interpreted = N
texte = The problem is that it's doing the first showif, which is appending the username to the db, then the next showif is finding that username. Switch your showif's around and the problem will go away ... :)>Hello,>>I am using this little bit of code to check if a user name exists in a>custom MyUsers.db>> [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=[PassW>ord_]&EmailAddr=[EmailAddr_][/Append]> User Added> [/ShowIf]>

> [ShowIf [Lookup>db=BldrUsers.db&value=[Uppercase][UserName_][/Uppercase]&lookinfield=UserNa>me&ReturnField=UserName&NotFound=]=[Uppercase][UserName_][/Uppercase]]> This User Name Already Exists. Try Another!> [/ShowIf]>>It works fine, meaning it functions, but the string This User Name>Already Exists. Try Another! shows no matter what. I want to show this>only if the name exists.Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net Associated Messages, from the most recent to the oldest:

Re: Missing something simple? (Rob Marquardt 1999) Re: Missing something simple? (Kenneth Grome 1999) Missing something simple? (charles kline 1999) Re: Missing something simple?? (Greg Tabet 1998) Re: Missing something simple?? (Morris Camp 1998) Re: Missing something simple?? (Michael Scott Davis 1998) Re: Missing something simple?? (charles kline 1998) Missing something simple?? (charles kline 1998)

The problem is that it's doing the first showif, which is appending the username to the db, then the next showif is finding that username. Switch your showif's around and the problem will go away ... :)>Hello,>>I am using this little bit of code to check if a user name exists in a>custom MyUsers.db>> [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=[PassW>ord_]&EmailAddr=[EmailAddr_][/Append]> User Added> [/ShowIf]>

> [ShowIf [Lookup>db=BldrUsers.db&value=[uppercase][UserName_][/Uppercase]&lookinfield=UserNa>me&ReturnField=UserName&NotFound=]=[uppercase][UserName_][/Uppercase]]> This User Name Already Exists. Try Another!> [/ShowIf]>>It works fine, meaning it functions, but the string This User Name>Already Exists. Try Another! shows no matter what. I want to show this>only if the name exists.Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net Kenneth Grome

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:

How To question on setting up downloads (1997) Cannot calculate prices (1997) WebCat2b13MacPlugIn - syntax to convert date (1997) [showif] based on data from [tcpconnect][tcpsend]? (2000) Multiple prices (1997) Building Calendars (1997) WebCatalog Hosting (1996) WebCat2b13 Command Reference Doc error (1997) [showif],[refferer],[include] in errormessages.db (2002) Summing fields (1997) Webstar 1.3.1 PPC (1997) Authenticate (1997) unable to launch acgi in WebCat (1997) webcat 2.1 new cart fields - please explain more (1998) OSX Continued (2000) orderfile and setlineitems (1998) Add all products to cart at once? (1997) searching for items that begin with a number (2004) relogin same user? (1998) credit card (1997)