Re: Using [showif]
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 25914
interpreted = N
texte = Sorry my stupidity, I was asking for the wrong group number :( -- Stuart TremainDigital Imaging Division The Ad-Libitum Group 48 Victoria Street North Sydney 2060 Australia Phone: +612 9959 5633 Fax: +612 9929 4146email: stuartt@adlib.com.au http://www.adlib.com.auOn Friday, 24 February 1939, Stuart Tremain
wrote: >I've used both methods but can't get it to work. >Any ideas? >-- >Stuart Tremain > >Digital Imaging Division >The Ad-Libitum Group >48 Victoria Street >North Sydney 2060 Australia >Phone: +612 9959 5633 Fax: +612 9929 4146 > >email: stuartt@adlib.com.au >http://www.adlib.com.au > >On Friday, 24 February 1939, Kenneth Grome wrote: >>>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 >> >> > > > >------------------------------------------------------------- >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 > >------------------------------------------------------------- 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:
Sorry my stupidity, I was asking for the wrong group number :( -- Stuart TremainDigital Imaging Division The Ad-Libitum Group 48 Victoria Street North Sydney 2060 Australia Phone: +612 9959 5633 Fax: +612 9929 4146email: stuartt@adlib.com.au http://www.adlib.com.auOn Friday, 24 February 1939, Stuart Tremain wrote: >I've used both methods but can't get it to work. >Any ideas? >-- >Stuart Tremain > >Digital Imaging Division >The Ad-Libitum Group >48 Victoria Street >North Sydney 2060 Australia >Phone: +612 9959 5633 Fax: +612 9929 4146 > >email: stuartt@adlib.com.au >http://www.adlib.com.au > >On Friday, 24 February 1939, Kenneth Grome wrote: >>>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 >> >> > > > >------------------------------------------------------------- >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 > >------------------------------------------------------------- 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
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:
Shopping Cart variation... (1997)
Download Question (1997)
error message (2000)
file truncation -- Mac plugin (2000)
[WebDNA] Help with iTools 9/WebDNA setup MacTel (2009)
How true is this? (1999)
All questions are welcome on this list (1997)
More than one db with the same namn (was: WC2f3) (1997)
Templates for Customer Database? (1997)
WebMerchant (1997)
Web Catalog vs. ICAT (1997)
input problem (1999)
[SearchString] usage (1997)
ie Posting error (2000)
Problem displaying search result (1997)
WebDNA 6 (2004)
Separate SSL Server (1997)
RedHat 7.0 (2001)
Cart Number sequence (1997)
WebCatalog Upgrade Pricing? (1997)