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 -- good 1,000.49 -- unknown 1.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 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: math and european notation (Grant Hulbert 1998)
  2. math and european notation (Peter Ostry 1998)
>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 -- good 1,000.49 -- unknown 1.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 | Typhoon 619/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:

[SearchString] usage (1997) Emailer (WebCat2) (1997) WebCatalog can't find database (1997) WebCat2.0 [format thousands .0f] no go (1997) What am I missing (1997) Password and Allow commands (1998) New Web Site Developers Database (1996) IE problems persist (2004) Gil's in the lead (1999) new WebDNA 5 command reference (2003) [WebDNA] php/mySQL version of WebDNA Speed Test? (2009) won't serve .tpl -permissions (2000) PCS Frames (1997) Subject: Authenticating users without dialog box (1997) line endings for Mac OS X files? (2003) Email Attachments (1998) RE: automatic reload of frameset (1997) Help name our technology! I found it (1997) Can't use old cart file (was One more try) (1997) RequiredFields notes ... (1997)