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:
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:
Re:listfiles-looking for slick solution (1997)
Problems with [Applescript] (1997)
Page Counters? (1997)
default value from Lookup (was Grant, please help me) (1997)
[lookup] again... (2003)
Safari browser and WebDNA set-cookies (2003)
Search Results (1998)
Formvariable won't update (1999)
Shipcost lookup? (1997)
To Use Cookies or Not To Use Cookies (2003)
shipcost (1997)
problems with 2 tags (1997)
Large databases in WebCat (1997)
Pulldown Menu Problem (2000)
Bug Report, maybe (1997)
https validation (2001)
can anyone confirm this behavior? (2003)
Huge databases and RAM (1998)
File perms (2002)
any suggestions for creating a multi-lingual site? (1999)