Re: Truncated numbers

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 30643
interpreted = N
texte = I'm pretty sure if you enter your price in your database without the comma (1234.56) and then use the following... [format thousands .2f][Priceone][/format]You'll get....1,234.56-Robert Wade CABIN6 DesignStuart Tremain wrote:> I have some prices in a db that look like this > 1,234.56 > > When I use $[format .2f][Priceone][/format] > the result gives me $1.23 > > The obvious problem is the comma, how can I stop this happening? > -- > Stuart Tremain > > Digital Imaging Division > The Ad-Libitum Group > 48 Victoria Street > North Sydney 2060 Australia > Phone: +612 9959 5633 Fax: +612 9929 4146 > > email: stuartt@adlib.com.au > http://www.adlib.com.au > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Associated Messages, from the most recent to the oldest:

    
  1. Re: Truncated numbers (Stuart Tremain 2000)
  2. Re: Truncated numbers (jpeacock@univpress.com 2000)
  3. Re: Truncated numbers (Howard Wolosky 2000)
  4. Re: Truncated numbers (Stuart Tremain 2000)
  5. Re: Truncated numbers (Kenneth Grome 2000)
  6. Re: Truncated numbers (Robert Wade 2000)
  7. Truncated numbers (Stuart Tremain 2000)
I'm pretty sure if you enter your price in your database without the comma (1234.56) and then use the following... [format thousands .2f][Priceone][/format]You'll get....1,234.56-Robert Wade CABIN6 DesignStuart Tremain wrote:> I have some prices in a db that look like this > 1,234.56 > > When I use $[format .2f][Priceone][/format] > the result gives me $1.23 > > The obvious problem is the comma, how can I stop this happening? > -- > Stuart Tremain > > Digital Imaging Division > The Ad-Libitum Group > 48 Victoria Street > North Sydney 2060 Australia > Phone: +612 9959 5633 Fax: +612 9929 4146 > > email: stuartt@adlib.com.au > http://www.adlib.com.au > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Robert Wade

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:

Questions. (1998) Help needed! (1998) Signal Raised Error (1997) Not really WebCat- (1997) Summing fields (1997) WebCat2 - storing unformatted date data? (1997) What about this [delete] situation? (1998) WC2b15 File Corruption (1997) WebCat2 beta 11 - new prefs ... (1997) Need relative path explanation (1997) WebCat2b13MacPlugIn - More limits on [include] (1997) [SHOWIF]s and empty arguments (1997) Sending emails (went[ot] ) (2002) Forumulas.db & Variables (2002) problems with 2 tags (1997) shoppingcart reload qty (1997) Mozilla/4. and Browser Info.txt (1997) WebCatalog for Postcards ? (1997) America Online Issues (1998) Yosemite and 8.1??? (1999)