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:

[WebDNA] lists opinion (2009) Another question (1997) Information on Vieworders.tpl (1998) [WebDNA] UK Based hosts (2018) OT - How to pay commissions to non US affiliates? (2000) WebCat2b12plugin - [search] is broken ... not! (1997) href name= link from dynamic URL possible? (1998) can WC render sites out? (1997) [WebDNA] Hosting Solution (2013) Forcing a NEWCART (1997) AcountAutherizer [fixed] (2002) Spaces inside [AppendFile] (1998) functions... (2005) Now you see it now you donīt (1997) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) New public beta available (1997) problems with 2 tags (1997) Dummy Credit Card Number for debug? (1997) [WebDNA] [convertchars] and ascii problem (2010) W* V4.2 SSL and webcat very slow (2000)