numero = 15766
interpreted = N
texte = Lookup is case sensitive. However, the [search] function can do what youwant - 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¬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:
Lookup is case sensitive. However, the [search] function can do what youwant - 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¬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.>>>>
John Hill
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...