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.comFon ++43-1-877 74 54 Fax ++43-1-877 74 54-21++++++++++++++++++++++++++++++++++++++++++++++++
Associated Messages, from the most recent to the oldest:
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.comFon ++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)