Re: case sensitivity in lookups

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 15769
interpreted = N
texte = >I've discovered in testing that if the TaxRates.db has the State field >entries as VA then a person who is lazy and enters as va, or a person >who is old-school and enters as Va is treated as notFound. It appears >that the lookup is case sensitive.You might try using [UpperCase] to change the user-entered text to uppercase inside the lookup:[Lookup db=xx.db&value=[Uppercase][ShipToState][/Uppercase]....]Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: case sensitivity in lookups (Grant Hulbert 1997)
  2. Re: case sensitivity in lookups (John Hill 1997)
  3. case sensitivity in lookups (Jim Turney 1997)
  4. Re: case sensitivity in lookups (Kenneth Grome 1997)
>I've discovered in testing that if the TaxRates.db has the State field >entries as VA then a person who is lazy and enters as va, or a person >who is old-school and enters as Va is treated as notFound. It appears >that the lookup is case sensitive.You might try using [uppercase] to change the user-entered text to uppercase inside the lookup:[Lookup db=xx.db&value=[uppercase][ShipToState][/Uppercase]....]Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 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:

shipCost not working v2.1b4 (1997) Three new problems, maybe a fourth (1997) Categories and Sub-categories (2003) [ot] Online Sales Tax (2005) WebDNA Challenge - Was: Why WebDNA is not popular (2002) WebCat2 - [format thousands] (1997) OT - Public Upload Security (2002) Installation webCatalog (French speakers please help) (1998) Looking up two prices in Formulas.db (1997) category index, drop down list (2005) Emailer (1998) Wonderin' whats the way (1998) [WebDNA] BBEdit WebDNA Configuration.plist (Language Module) (2013) WebCat2 Append problem (B14Macacgi) (1997) HomePage Caution (1997) Out of the woodwork (2007) using showpage and showcart commands (1996) [WebDNA] Putting '&search' into URL killing all search contexts on my sites (2010) re: Large Database Options? (1999) [WebDNA] install issues on Centos 6 (2017)