Grant, please help me ...
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 12562
interpreted = N
texte = Grant, please look at this and tell me what I'm doing wrong, if anything ...I have to use a database other than the users.db for securing my pages, so I cannot use the [protect] feature of WebCat2. That's why I created my own WebDNA to do the same thing:[showif [lookup db=members.db&value=[uppercase][username][/uppercase]&lookinfield=user&returnfie ld=pass¬found=sorryNoPass]![password][authenticate something][/showif]This WebDNA is supposed to:1- Take the [username] value which is cached in the browser 2- Make it into all uppercase 3- Look for the resulting uppercase value in the [user] field of the members.db.If there's no [username] cached in the browser, the lookup should NOT find any matching record, and therefore, the lookup value should equate to sorryNoPass ... which makes the showif true, and therefore the authenticate box should appear.However, when there's no [username] value cached in the browser, such as whenever I restart Netscape, this WebDNA does NOT display the authenticate box.Why not?The only thing I can think of is that the value of the lookup is NOT being set to sorryNoPass when there's no username cached in the browser. And if this is the case, my understanding of how [lookup] works is wrong, and I need to clear that up.I always thought that no matter what was going on inside the lookup, it's value would always equate to the notfound value unless everything went 'right' with the lookup and the 'returnfield' was actually returned with a value in it.But from what I 'think' I'm seeing in my own WebDNA, the lookup value seems to NOT equate to the notfound value when there no record that matches the search parameter.This is kind of important to me for obvious reasons, I just want to understand what's really going on here so I can work around it if possible. Thanks!Sincerely, Ken Grome WebDNA Solutions http://www.hui.net/dna/webdna.html
Associated Messages, from the most recent to the oldest:
Grant, please look at this and tell me what I'm doing wrong, if anything ...I have to use a database other than the users.db for securing my pages, so I cannot use the
[protect] feature of WebCat2. That's why I created my own WebDNA to do the same thing:[showif [lookup db=members.db&value=
[uppercase][username][/uppercase]&lookinfield=user&returnfie ld=pass¬found=sorryNoPass]!
[password][authenticate something][/showif]This WebDNA is supposed to:1- Take the
[username] value which is cached in the browser 2- Make it into all uppercase 3- Look for the resulting uppercase value in the [user] field of the members.db.If there's no
[username] cached in the browser, the lookup should NOT find any matching record, and therefore, the lookup value should equate to sorryNoPass ... which makes the showif true, and therefore the authenticate box should appear.However, when there's no
[username] value cached in the browser, such as whenever I restart Netscape, this WebDNA does NOT display the authenticate box.Why not?The only thing I can think of is that the value of the lookup is NOT being set to sorryNoPass when there's no username cached in the browser. And if this is the case, my understanding of how
[lookup] works is wrong, and I need to clear that up.I always thought that no matter what was going on inside the lookup, it's value would always equate to the notfound value unless everything went 'right' with the lookup and the 'returnfield' was actually returned with a value in it.But from what I 'think' I'm seeing in my own WebDNA, the lookup value seems to NOT equate to the notfound value when there no record that matches the search parameter.This is kind of important to me for obvious reasons, I just want to understand what's really going on here so I can work around it if possible. Thanks!Sincerely, Ken Grome WebDNA Solutions http://www.hui.net/dna/webdna.html
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:
Help formatting search results w/ table (1997)
authnet good news (2003)
Some Advise needed (1997)
much help needed NEWBIE alert (2000)
Re[2]: Field Problem (2000)
[BoldWords] WebCat.acgib15Mac (1997)
Setting up shop (1997)
Summing fields (1997)
Formating found categories (1997)
missing records (1998)
Separate SSL Server (1997)
Quit revisited (1997)
Credit card types (1997)
ReturnRaw and redirect (1997)
Country & Ship-to address & other fields ? (1997)
WebCommerce: Folder organization ? (1997)
Secure server question (1997)
NT considerations (1997)
FREE Stuff .. (2003)
WebDNA Build Area (linux) (2004)