Re: Using [showif]

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 25912
interpreted = N
texte = Thanks Ken I'll get into it. -- 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, 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 Associated Messages, from the most recent to the oldest:

    
  1. Re: Using [showif] within [lineitems] [code fragment] (Kenneth Grome 2000)
  2. Re: Using [showif] within [lineitems] [code fragment] (Andrew Vernon 2000)
  3. Re: Using [showif] within [lineitems] [code fragment] (Derrick Puckett 2000)
  4. Re: Using [showif] within [lineitems] [code fragment] (Derrick Puckett 2000)
  5. Re: Using [showif] within [lineitems] [code fragment] (Andrew Vernon 2000)
  6. Re: Using [showif] within [lineitems] (Glenn Busbin 2000)
  7. Re: Using [showif] within [lineitems] (Andrew Vernon 2000)
  8. Re: Using [showif] within [lineitems] (Rob Marquardt 2000)
  9. Re: Using [showif] within [lineitems] (Kenneth Grome 2000)
  10. Re: Using [showif] within [lineitems] (Glenn Busbin 2000)
  11. Using [showif] within [lineitems] (Andrew Vernon 2000)
  12. Re: Using [showif] (Stuart Tremain 2000)
  13. Re: Using [showif] (Stuart Tremain 2000)
  14. Re: Using [showif] (Stuart Tremain 2000)
  15. Re: Using [showif] (Kenneth Grome 2000)
  16. Re: Using [showif] (Stuart Tremain 2000)
  17. Re: Using [showif] (Kenneth Grome 2000)
  18. Using [showif] (Stuart Tremain 2000)
  19. Re: Using [Showif] tag. Mac (Grant Hulbert 1997)
  20. Using [Showif] tag. Mac (Wayne Morishige 1997)
Thanks Ken I'll get into it. -- 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, 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 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:

what servers are supported for Typhoon? (1997) Orderfile Vars (2003) Orderfile context problem (1998) Changing price for a SLU based on options (size, etc.) (1997) Page Breaks in Word (2003) send mail problem? (1997) 5.0 tips etc (2003) WC TableGrinder (1997) WebDNA Partner edition .. (2002) [WebDNA] [BULK] The WebDNA Server Module / web services (2012) OK, here goes... (1997) AOL and webcat (1998) WebCat2 - [include] tags (1997) RE: Nesting [ListFiles] (1998) [WebDNA] Bug in Emailer (2008) Me know logical no need (2002) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) [cart] not being interpreted inside [founditems] (1997) Pref settings? (1998) Another Excel Problem (2003)