What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

Re: [WebDNA] checking for mixed case text

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 102727
interpreted = N
texte = Well done Ken! That's an approach I'd not thought of and to me seems like the most straight forward and re-usable. I now remember getting hung up on the [lookup] because it is in fact case sensitive. That is after all the main point of this thread... Marc Kenneth Grome wrote: >> But I cannot figure out how to get WebDNA to check a text >> string to report whether it is mixed case or not. > > > Here's another approach: > > Set the text string to a text variable (var) then create an > up.db with only one field (letter). Create one record in > this db for each uppercase letter in the alphabet, plus one > record for each non-alphabetic character that might occur in > a name. > > Then use this code: > > [math show=f]numUp=0[/math] > [text]numChars=[countchars][var][/countchars][/text] > > [listchars chars=[var]] > [showif [char]=[lookup > db=up.db&value=[char]&lookinfield=letter&returnfield=letter]] > [math show=f]numUp=numUp+1[/math] > [/showif] > [/listchars] > > [showif [numChars]=[numUp]] > all letters are uppercase > [/showif] > > [showif [numChars]![numUp]] > some letters are not uppercase > [/showif] > > > Sincerely, > Ken Grome > > > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > . > -- ------------------------------------------- Marc Thompson Software Engineer Office of Information Technology University of Utah 801.585.9264 marc.thompson@utah.edu ------------------------------------------- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] checking for mixed case text (Dana E Keil 2009)
  2. RE: [WebDNA] checking for mixed case text ("Olin Lagon" 2009)
  3. Re: [WebDNA] checking for mixed case text (Marc Thompson 2009)
  4. Re: [WebDNA] checking for mixed case text (christophe.billiottet@webdna.us 2009)
  5. Re: [WebDNA] checking for mixed case text (Matthew Bohne 2009)
  6. Re: [WebDNA] checking for mixed case text (Kenneth Grome 2009)
  7. Re: [WebDNA] checking for mixed case text (Govinda 2009)
  8. Re: [WebDNA] checking for mixed case text (Terry Wilson 2009)
  9. Re: [WebDNA] checking for mixed case text (Brian Fries 2009)
  10. [WebDNA] checking for mixed case text (Dana E Keil 2009)
Well done Ken! That's an approach I'd not thought of and to me seems like the most straight forward and re-usable. I now remember getting hung up on the [lookup] because it is in fact case sensitive. That is after all the main point of this thread... Marc Kenneth Grome wrote: >> But I cannot figure out how to get WebDNA to check a text >> string to report whether it is mixed case or not. > > > Here's another approach: > > Set the text string to a text variable (var) then create an > up.db with only one field (letter). Create one record in > this db for each uppercase letter in the alphabet, plus one > record for each non-alphabetic character that might occur in > a name. > > Then use this code: > > [math show=f]numUp=0[/math] > [text]numChars=[countchars][var][/countchars][/text] > > [listchars chars=[var]] > [showif [char]=[lookup > db=up.db&value=[char]&lookinfield=letter&returnfield=letter]] > [math show=f]numUp=numUp+1[/math] > [/showif] > [/listchars] > > [showif [numChars]=[numUp]] > all letters are uppercase > [/showif] > > [showif [numChars]![numUp]] > some letters are not uppercase > [/showif] > > > Sincerely, > Ken Grome > > > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > . > -- ------------------------------------------- Marc Thompson Software Engineer Office of Information Technology University of Utah 801.585.9264 marc.thompson@utah.edu ------------------------------------------- Marc Thompson

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:

method of payment (1997) [shipCost] math formula? (1997) WebCat B13 Mac CGI -- Frames question (1997) WebDNA creates DUPLICATE SHOPPING CART NUMBERS (2004) WebCatalog Mac 2.1b3 (1997) WCS Newbie question (1997) Re:no [search] with NT (1997) [Replace] really replaces? (2000) calculating tax rates, mail order solutions and version 2 (1997) FINAL: STILL not starting on bootup (2002) pc (1997) delete a record and ssl (2005) Car Database (2002) Nesting format tags (1997) Next X hits (1996) db caching in bizarre ways (2001) ups quickcost [repost] (1999) WebDNA 5.0 freeBSD?!!? (2003) Menu Syntax on Edit/Add templates (1998) REPLACE & MAX/STARTAT parameters doesn't work? (2000)