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 variouscommands. 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 valuesand 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 andcomma for decimal values (1.000,00).One solution would be to tell the clients (which are uploading via ftp) tochange the number format in their database, but they _will_ forget to doso, 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 duringcalculation 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 OstryVienna/Austriapo@ostry.comwww.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 variouscommands. 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 valuesand 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 andcomma for decimal values (1.000,00).One solution would be to tell the clients (which are uploading via ftp) tochange the number format in their database, but they _will_ forget to doso, 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 duringcalculation 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 OstryVienna/Austriapo@ostry.comwww.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)