Re: Using [showif]
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 25911
interpreted = N
texte = >Is this waht you mean? > >[ShowIf [lookup db=users.db&value=[username]&lookinfield=group&returnfield=[group]]=group01]Hello[/Showif]Well, your code has a few problems. Assuming you always store your usernames as uppercase values, I meant something like this:[ShowIf [url][lookup db=users.db&value=[uppercase][username][/uppercase]&lookinfield=user&returnfield=group][/url]=[url]group01[/url]]Hello[/Showif]But if you do not store usernames as all uppercase yet you want the proper results even when the visitor enters the wrong case for certain letters, you will have to use a search instead, like this:[ShowIf [url][search db=users.db&equserdatarq=[username]&max=1][founditems][/search][/url]=[url]group01[/url]]Hello[/Showif]================================ Kenneth Grome, WebDNA Consultant 808-737-6499, http://webdna.net ================================------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to
.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
Associated Messages, from the most recent to the oldest:
>Is this waht you mean? > >[ShowIf [lookup db=users.db&value=[username]&lookinfield=group&returnfield=[group]]=group01]Hello[/Showif]Well, your code has a few problems. Assuming you always store your usernames as uppercase values, I meant something like this:[ShowIf [url][lookup db=users.db&value=[uppercase][username][/uppercase]&lookinfield=user&returnfield=group][/url]=[url]group01[/url]]Hello[/Showif]But if you do not store usernames as all uppercase yet you want the proper results even when the visitor enters the wrong case for certain letters, you will have to use a search instead, like this:[ShowIf [url][search db=users.db&equserdatarq=[username]&max=1][founditems][/search][/url]=[url]group01[/url]]Hello[/Showif]================================ Kenneth Grome, WebDNA Consultant 808-737-6499, http://webdna.net ================================------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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
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:
Forumulas.db & Variables (2002)
The Form authentication trick (2000)
Show first couple of lines. (2003)
WebCat2: multiple currency support (1997)
OPEN MARKET PATENTS SOUND ECOMMERCE ALARM (1998)
how to include a name in from or to using Sendmail? (2003)
!!!!!!!!!!String Search!!!!!!!!!!!!!!!!!! (2001)
Referrer field to header field conversion (1997)
I'm tired of all this! (2000)
Emailer+NetTen [same machine]=? (2000)
Banner DNA (1997)
Fwd: Bug at start of Apache 2 with iTools 7 (2003)
Help Encrypt/Decrypt eMail (2003)
Summing fields (1997)
Roundup function? (1997)
BR (1997)
Re1000001: Setting up shop (1997)
Help! WebCat2 bug (1997)
Stop the madness. (1997)
Need help with emailer- 2 issues (1997)