math and european notation

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 16168
interpreted = N
texte = I am new to WebCat so I might not fully understand the syntax of various commands. One problem now: I show a shopping cart in a table and want to multiply quantity with price. [math][itemprice]*[quantity][/math] gives a wrong result with some values and I did some tests:[itemprice] is 80,00 and [math][itemprice]*1[/math] displays 80 which is right. but: [itemprice] is 17,90 and [math][itemprice]*1[/math] displays 9 --> huh?The [math] tag simply shows only values after the comma if they are not zero. I believe this is a problem with europaean notation - dot for thousands and comma for decimal values (1.000,00). One solution would be to tell the clients (which are uploading via ftp) to change the number format in their database, but they _will_ forget to do so, you know...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?Or is there a better solution? Peter______________ Peter Ostry Vienna/Austria po@ostry.com www.ostry.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 am new to WebCat so I might not fully understand the syntax of various commands. One problem now: I show a shopping cart in a table and want to multiply quantity with price. [math][itemprice]*[quantity][/math] gives a wrong result with some values and I did some tests:[itemprice] is 80,00 and [math][itemprice]*1[/math] displays 80 which is right. but: [itemprice] is 17,90 and [math][itemprice]*1[/math] displays 9 --> huh?The [math] tag simply shows only values after the comma if they are not zero. I believe this is a problem with europaean notation - dot for thousands and comma for decimal values (1.000,00). One solution would be to tell the clients (which are uploading via ftp) to change the number format in their database, but they _will_ forget to do so, you know...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?Or is there a better solution? Peter______________ Peter Ostry Vienna/Austria po@ostry.com www.ostry.com Peter Ostry

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:

websitepro/webcat/registry? (1998) Summing fields (1997) email problem (2005) Need relative path explanation (1997) Unix DB Permission Error (2002) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) [WebDNA] New problem with [ShowNext] (2010) RequiredFields parameter (1998) Emailer help....! (1997) Setting up the server (1997) grouping fields (1999) Calendar (1997) suffix mapping for NT? (1997) WebCatalog stalls (1998) Email template names (1997) redirect within the ErrorMessages.db (2003) RE: Redirect (1998) Netscape (1997) Search returns all, not 20 (1997) Emailer setup (1997)