Re: Using [showif]
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 25913
interpreted = N
texte = I've used both methods but can't get it to work. Any ideas? -- 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:
I've used both methods but can't get it to work. Any ideas? -- 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:
emailer on Windows Beta 18 (1997)
Online reference (1997)
Webstar 1.3.1 PPC (1997)
Problems appending to database (1997)
Re1000001: Setting up shop (1997)
Summing a field full of numbers ... (1997)
Need relative path explanation (1997)
changing order number (1998)
Email Set-Up? (1997)
[WriteFile] problems (1997)
WebCat2: multiple currency support (1997)
Problem with broken images (2004)
Default contains WEBDNA (1998)
headers (2000)
Almost a there but..bye bye NetCloak (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
WebCat2.0 [format thousands .0f] no go (1997)
Buying sans cart (1997)
multi-table date sort problem thingy (2002)
WebCatalog can't find database (1997)