Re: Truncated numbers
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 30709
interpreted = N
texte = Yes I think the best way to solve this, and any others that I find, will be to clean this supplied dB -- Stuart TremainDigital Imaging Division The Ad-Libitum Group 48 Victoria Street North Sydney 2060 Australia Phone: +612 9959 5633 Fax: +612 9929 4146email: stuartt@adlib.com.au http://www.adlib.com.auOn Friday, 9 June 1939, jpeacock@univpress.com wrote: >1,234.56 is not a number, it is a string. Never put commas into anything you >wish to treat as a number; you can always use format to output the >comma-delimited number. Ken's solution can be used to fix it, but it is bad >design to have to fix it at all. Numbers are 0-9 and the >decimal point only. > >John Peacock > > >____________________Reply Separator____________________ >Subject: Truncated numbers >Author:
(WebCatalog Talk) >Date: 4/20/2000 12:58 PM > >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:
Yes I think the best way to solve this, and any others that I find, will be to clean this supplied dB -- Stuart TremainDigital Imaging Division The Ad-Libitum Group 48 Victoria Street North Sydney 2060 Australia Phone: +612 9959 5633 Fax: +612 9929 4146email: stuartt@adlib.com.au http://www.adlib.com.auOn Friday, 9 June 1939, jpeacock@univpress.com wrote: >1,234.56 is not a number, it is a string. Never put commas into anything you >wish to treat as a number; you can always use format to output the >comma-delimited number. Ken's solution can be used to fix it, but it is bad >design to have to fix it at all. Numbers are 0-9 and the >decimal point only. > >John Peacock > > >____________________Reply Separator____________________ >Subject: Truncated numbers >Author: (WebCatalog Talk) >Date: 4/20/2000 12:58 PM > >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
Stuart Tremain
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:
A *secret* new webdna tag !!! (1999)
Freeze (2003)
Shipping [grandtotal] solution (1997)
faxing orders (2000)
ShowIf, If, XML Syntax.... (2004)
Help name our technology! I found it (1997)
Snake Bites (1997)
Almost a there but..bye bye NetCloak (1997)
Quit revisited (1997)
RE: OK, here goes... (1997)
Help! WebCat2 bug (1997)
Credit card number for testing (2003)
Sort of a Dilema! (1998)
problems with 2 tags (1997)
WC --> printer (1998)
PhotoMill -> PhotoMaster (1997)
Questions To Answer (1997)
RE: too many nested [xxx] (1997)
Categories (2000)
[WriteFile] problems (1997)