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 Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
>>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 Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://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)