Re: math and european notation
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 16172
interpreted = N
texte = >I found a workaround using nested format:>[format ,2f][math][format f][itemprice][/format]*[quantity][/math][/format]>That works and seems to do some reformatting on the price field during>calculation even with european format in the database.>Does [format f]>eliminate all punctuations and treats the numbers only?Not intentionally, so be careful -- this may be an accidental side-effect.Currently all numbers are expected to be stored in American format in your database, and in fact should not contain commas either. We expect1000.49 -- good1,000.49 -- unknown1.000,49 -- unknownThe upcoming 2.1 release will provide a special [ConvertChars] ability to remove periods and convert commas to periods so that your vendors can type European-style numbers:1.000,49 -> ConvertChars -> 1000.49 (expected WebCat format)Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>I found a workaround using nested format:>[format ,2f]
[math][format f][itemprice][/format]*[quantity][/math][/format]>That works and seems to do some reformatting on the price field during>calculation even with european format in the database.>Does [format f]>eliminate all punctuations and treats the numbers only?Not intentionally, so be careful -- this may be an accidental side-effect.Currently all numbers are expected to be stored in American format in your database, and in fact should not contain commas either. We expect1000.49 -- good1,000.49 -- unknown1.000,49 -- unknownThe upcoming 2.1 release will provide a special
[convertchars] ability to remove periods and convert commas to periods so that your vendors can type European-style numbers:1.000,49 -> ConvertChars -> 1000.49 (expected WebCat format)Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Grant Hulbert
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:
WebCat2 several catalogs? (1997)
(2000)
suffix mapping for NT? (1997)
Review comparison by PC Magazine: Open for On-line Business (1997)
Great product and great job ! (1997)
list items (1998)
[protect] on NT? (1997)
NT vs Mac (1997)
Relevancy Rating (1998)
Multiple cart additions (1997)
NT vs Mac (1997)
Caching [include] files ... (1997)
[WebDNA] [announce] CentOS and RedHat support for CICADA (2009)
Practical Uses (2003)
How to implement 'email to a friend' feature? (2002)
How to get shownext to just shownext once (1997)
[date format] w/in sendmail (1997)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
RE: Languages (1997)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)