Re: Lookup Notfound

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17166
interpreted = N
texte = >>A couple of possibilities: you might actually have a matching record in >>your database that has a blank in it, or perhaps the [ipusername] field has >>an & embedded in it, which would screw up the rest of the variables in the >>lookup tag. If that's it, then [url][ipusername][/url] is the answer. > >Duh yes there is such a record I was thinking that if it didn't find a >value in the db then it would return notfound. SuperDuh! Might be nice to >haves some showif capabilites inside the lookup tag.Doing this would work:[lookup db=../ipusers.db&lookinfield=ipusername&value=[ipusername]&returnfield=ipurl¬found=empty.tpl] [showif [lookup db=../ipusers.db&lookinfield=ipusername&value=[ipusername]&returnfield=ipurl]=]empty.tpl[/showif]Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Associated Messages, from the most recent to the oldest:

    
  1. Re: Lookup Notfound (Jay Van Vark 1998)
  2. Re: Lookup Notfound (Bob Mosebar 1998)
  3. Re: Lookup Notfound (Kenneth Grome 1998)
  4. Re: Lookup Notfound (Bob Minor 1998)
  5. Re: Lookup Notfound (Grant Hulbert 1998)
  6. Re: Lookup Notfound (Kenneth Grome 1998)
  7. Re: Lookup Notfound (Kenneth Grome 1998)
  8. Re: Lookup Notfound (Bob Minor 1998)
  9. Re: Lookup Notfound (Bob Minor 1998)
  10. RE: Lookup Notfound (Olin 1998)
  11. Re: Lookup Notfound (Kenneth Grome 1998)
  12. Lookup Notfound (bob 1998)
>>A couple of possibilities: you might actually have a matching record in >>your database that has a blank in it, or perhaps the [ipusername] field has >>an & embedded in it, which would screw up the rest of the variables in the >>lookup tag. If that's it, then [url][ipusername][/url] is the answer. > >Duh yes there is such a record I was thinking that if it didn't find a >value in the db then it would return notfound. SuperDuh! Might be nice to >haves some showif capabilites inside the lookup tag.Doing this would work:[lookup db=../ipusers.db&lookinfield=ipusername&value=[ipusername]&returnfield=ipurl¬found=empty.tpl] [showif [lookup db=../ipusers.db&lookinfield=ipusername&value=[ipusername]&returnfield=ipurl]=]empty.tpl[/showif]Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net 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:

WebCatalog Plug-in for Webstar. (1997) emailer truncates last letter! (1997) Shopping Cart ID (1998) oops private message leaked into talk list (1997) Add to a field (1998) [math] storage of variables (1997) Date math (1997) Drop Down Menus (2002) [SHOWIF] (1997) Searching multiple Databases (1997) New public beta available (1997) .htm file tags not showing up (2000) WebCat 3.04-3.07 plug-in dying on server.... (2000) Using WC for Bulk Emailings (1997) WebCatalog and WebTen (1997) Protect (1997) WebDNA install - linux (permissions rehash?) (2002) Bug Report, maybe (1997) Pithy questions on webcommerce & siteedit (1997) Languages (1997)