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:
>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:
PDF on the fly - how to? (2005)
RE: OK, here goes... (1997)
Server crash (1997)
How to include weather (2000)
Re:HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997)
WebCat2b12plugin - [search] is broken ... not! (1997)
RE: is sku a REQUIRED field on NT (1997)
Show new (2003)
WebCat2b15MacPlugin - [protect] (1997)
Sorting Orders (1997)
WebCat2 - storing unformatted date data? (1997)
Re[3]: 2nd WebCatalog2 Feature Request (1996)
WebCat2b15MacPlugin - showing [math] (1997)
possible, WebCat2.0 and checkboxes-restated (1997)
Running 2 two WebCatalog.acgi's (1996)
virtual virtual hosted store.... (1998)
Sendmail problem (2002)
select multiple (1997)
Extracting a Word (2000)
using showpage and showcart commands (1996)