Re: formatting a number

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 22302
interpreted = N
texte = At 10:24 Uhr -0600 05.01.1999, Sue Ann Sanders wrote:>When my customer adds a record, they have a field where they enter a >number. I need single digit numbers to be 2 digits so that they sort >correctly. For example, if they enter 1, I need to add it to the database >as 01. > >I read the Format info in the WC online Reference but didn't see how to >do this. How can I accomplish this? Look if the input is less than 10 and add a leading zero:[append db=my.db]FIELD= [showif [math][v_input][math]<10]0[/showif] [v_input][/append](all on one line, of course) Peter++++++++++++++++++++++++++++++++++++++++++++++++ Peter Ostry - Vienna/Austria - www.ostry.com Fon ++43-1-877 74 54 Fax ++43-1-877 74 54-21 ++++++++++++++++++++++++++++++++++++++++++++++++ Associated Messages, from the most recent to the oldest:

    
  1. Re: formatting a number (Kenneth Grome 1999)
  2. Re: formatting a number (Grant Hulbert 1999)
  3. Re: formatting a number (Peter Ostry 1999)
  4. Re: formatting a number (Grant Hulbert 1999)
  5. Re: formatting a number (Peter Ostry 1999)
  6. formatting a number (Sue Ann Sanders 1999)
At 10:24 Uhr -0600 05.01.1999, Sue Ann Sanders wrote:>When my customer adds a record, they have a field where they enter a >number. I need single digit numbers to be 2 digits so that they sort >correctly. For example, if they enter 1, I need to add it to the database >as 01. > >I read the Format info in the WC online Reference but didn't see how to >do this. How can I accomplish this? Look if the input is less than 10 and add a leading zero:[append db=my.db]FIELD= [showif [math][v_input][math]<10]0[/showif] [v_input][/append](all on one line, of course) Peter++++++++++++++++++++++++++++++++++++++++++++++++ Peter Ostry - Vienna/Austria - www.ostry.com Fon ++43-1-877 74 54 Fax ++43-1-877 74 54-21 ++++++++++++++++++++++++++++++++++++++++++++++++ Peter Ostry

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:

Why WebMerchant not working? (1999) Major bug report on rootbeer (1997) RE: [WebDNA] Crashing (2008) Bug Report, maybe (1997) emailer error 103 part ii (1997) Showif, Hideif reverse logic ? (1997) syntax question, not in online refernce (1997) Entry pages (was: WebCatalog MAJOR drawback) (1998) date (2002) Cart Number sequence (1997) 2.0 Info (1997) Searching Multiple DBs (1997) Snake Bites (1997) Emailer Problem (1999) A Global Variable (1997) Separate SSL Server (1997) Initiating NewCart (1997) Seeking Better Display of results... (1997) [SHOWNEXT] Examples (1997) Add - optional parameters textA=.... (1997)