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:

[searchString] (1997) I've had it! (1999) Date to Daze (1999) WC2f3 (1997) A question on sub-categories (1997) RE: [WebDNA] Cheers (2008) A little syntax help (1997) WebCat2: Items xx to xx shown, etc. (1997) Return records from another (1997) frustrated with search (2001) [WebDNA] FUNCTION help (2013) Setting up shop (1997) Securing/hiding database file (2000) WebMerchant and PC Auth Hub (1999) PCS Frames (1997) WebCatalog [FoundItems] Problem - AGAIN - (1997) syntax question, not in online refernce (1997) Linux Beta4 problems with multirecord returns (2000) PSC recommends what date format yr 2000??? (1997) Online Docs? (1997)