Re: case sensitivity in lookups

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 15766
interpreted = N
texte = Lookup is case sensitive. However, the [search] function can do what you want - it's just not as compact. At 11:59 PM 12/21/97, you wrote: >Using the GeneralStore method of determining Sales Tax charges, the >abbreviation of the Ship-To state is requested value=[ShipToState] size=2> in the ShoppingCart.tmpl and the Invoice.tmpl >calls the taxRate formula [lookup >db=TaxRates.db&lookInField=State&value=[ShipToState]&returnField=taxRate&no tFoun >d=0.00] > >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. Is there a way around this case >sensitivity? In this particular case it's easy to just enter into >TaxRates.db every case permutation of the three states where we must charge >taxes. This could get ugly in other lookups. > > > > 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)
Lookup is case sensitive. However, the [search] function can do what you want - it's just not as compact. At 11:59 PM 12/21/97, you wrote: >Using the GeneralStore method of determining Sales Tax charges, the >abbreviation of the Ship-To state is requested value=[ShipToState] size=2> in the ShoppingCart.tmpl and the Invoice.tmpl >calls the taxRate formula [lookup >db=TaxRates.db&lookInField=State&value=[ShipToState]&returnField=taxRate&no tFoun >d=0.00] > >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. Is there a way around this case >sensitivity? In this particular case it's easy to just enter into >TaxRates.db every case permutation of the three states where we must charge >taxes. This could get ugly in other lookups. > > > > John Hill

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:

Pre-flight public flag (1997) PIXO support (1997) Mac 3.0.5b11 PI -- template cache and aliases (1999) Pithy questions on webcommerce & siteedit (1997) LOOP and IF statements (1997) Unable to append (2001) [WebDNA] Feature requests - date format (2009) redirect from the errorsMessages.db entry (1997) Ok here is a question? (1997) Re:Has this happened to you? (1997) Storebuilder SOLVED!!!!!!! (2003) Summary search -- speed (1997) WebCat2b13MacPlugIn - more [date] problems (1997) [Repost] Triggers, again SM??? (2000) search engines (2001) RE: New WebCatalog Version !!! (1997) Re:ListFields and [name] (1997) WildWEBCAT98 Voting is OPEN! (1999) Summing fields (1997) math on date? (1997)