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:

Price Change (2000) Enhancement Request for WebCatalog-NT (1996) RE: WebCatalog NT beta 18 now available (1997) SKU generator? (1998) Calculating Shipping (1997) Include a big block of text (1997) [WebDNA] line/Row Insert (2017) [showif] with ! (2000) [SHOWIF]s and empty arguments (1997) [WebDNA] in case anyone out here is actually using the "WebdnaCodeSparker" framework... (2013) WebCatalog2 for NT Beta Request (1997) Shop from PDF (2004) ShowIf variables (1997) [WebDNA] Function "libraries" (2009) Problem with my orders (1998) IIS4 (1998) WebCat2b13MacPlugin - [math][date][/math] problem (1997) [sendmail] and [formvariables] (1997) Re:2nd WebCatalog2 Feature Request (1996) Chat (2002)