Re: default value from Lookup (was Grant, please help me)

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 12590
interpreted = N
texte = >Does a lookup result in a blank value (instead of with the notfound value) >when the search part of the lookup finds zero matching records? That's what >*seems* to be happening ... :)No, that's the reason for the notFound parameter. If you leave off the notFound parameter, it returns nothing, but if you specify one then that's supposed to be what's returned.So yes, your reasoning is correct, but I don't know why the results are wrong. It may be a subtle field naming mismatch, wrong number of tabs, or even an actual blank entry in your lookup database.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Associated Messages, from the most recent to the oldest:

    
  1. Re: default value from Lookup (was Grant, please help me) (Kenneth Grome 1997)
  2. Re: default value from Lookup (was Grant, please help me) (Grant Hulbert 1997)
  3. Re: default value from Lookup (was Grant, please help me) (Kenneth Grome 1997)
  4. Re: default value from Lookup (was Grant, please help me) (Grant Hulbert 1997)
  5. Re: default value from Lookup (was Grant, please help me) (Kenneth Grome 1997)
  6. Re: default value from Lookup (was Grant, please help me) (Grant Hulbert 1997)
  7. Re: default value from Lookup (was Grant, please help me) (Kenneth Grome 1997)
  8. Re: default value from Lookup (was Grant, please help me) (Grant Hulbert 1997)
>Does a lookup result in a blank value (instead of with the notfound value) >when the search part of the lookup finds zero matching records? That's what >*seems* to be happening ... :)No, that's the reason for the notFound parameter. If you leave off the notFound parameter, it returns nothing, but if you specify one then that's supposed to be what's returned.So yes, your reasoning is correct, but I don't know why the results are wrong. It may be a subtle field naming mismatch, wrong number of tabs, or even an actual blank entry in your lookup database.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Grant Hulbert

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:

Re:Virtual hosting and webcatNT (1997) Running 2 two WebCatalog.acgi's (1996) Problem (1997) shipping help (1998) Copyright ? (1997) WebCatalog for guestbook ? (1997) mimeheaders to allow back button to work on a posted page? (2004) b12 cannot limit records returned and more. (1997) Large Database Options? (1999) 2nd WebCatalog2 Feature Request (1996) Hard Questions ? (1997) Another bug to squash (WebCat2b13 Mac .acgi) (1997) Help! WebCat2 bug (1997) Reversed words (1997) Price and Formula.db (2002) Any 4.5 to 5.0 upgrade gotchas? [OT] (2003) WebCat2b12--[searchstring] bug (1997) [OT] Read and weep (2003) WebDNA5 & Tiger (2006) WebCat2b13 Command Reference Doc error (1997)