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 WadeCABIN6 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:
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 WadeCABIN6 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)