case sensitivity in lookups

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 15764
interpreted = N
texte = Using the GeneralStore method of determining Sales Tax charges, the abbreviation of the Ship-To state is requested in the ShoppingCart.tmpl and the Invoice.tmpl calls the taxRate formula [lookup db=TaxRates.db&lookInField=State&value=[ShipToState]&returnField=taxRate¬Foun 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)
Using the GeneralStore method of determining Sales Tax charges, the abbreviation of the Ship-To state is requested in the ShoppingCart.tmpl and the Invoice.tmpl calls the taxRate formula [lookup db=TaxRates.db&lookInField=State&value=[ShipToState]&returnField=taxRate¬Foun 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. Jim Turney

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:

CVS Files for databases (2000) textarea data entry and display (2000) Running _every_ page through WebCat ? (1997) WC2b15 - [HTMLx]...[/HTMLx] problems (1997) Comments in db? (1997) [SHOWIF AND/OR] (1997) Signal Raised Error (1997) Validating a date (2000) WC2.0 Memory Requirements (1997) Great product and great job ! (1997) WebCat2b15MacPlugIn - [authenticate] not [protect] (1997) Type 2 errors with WebCatalog.acgi (1997) Problem (1997) FoundItems Question (1998) PCS Frames (1997) b12 cannot limit records returned and more. (1997) Migrating to NT (1997) Not reading code (1997) RE: Quantity (1998) WebDNA release (2005)