Math Bug
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 25443
interpreted = N
texte = I've run across a math bug when summarizing a large number of records usingthis technique:[some search context][math][founditems][commission]+[/founditems]0[/math][/search]Once the search hits about the 130-135th record the total which should looklike: 79924.24 instead gets formatted as 79924.2399999999. I've zappedgremlins, reloaded the database, changed the startat value, verified thatall values are integers (all are formatted x.xx ), even modified thecontents of the records with different values and still the computed valuegets formatted as .xx99999999.As a further test I created a test db and wrote out the commission valuesfrom the problem db to the test db and the results are the same - althoughthe problem begins at the 125th record - *does not* appear in the 126threcord but comes back at the 127th record. What the heck is going on here?Running 3.04PI w/Web* 4.0 on a G4 w/OS 8.6ThanksMarty Schmid-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to
.This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
I've run across a math bug when summarizing a large number of records usingthis technique:[some search context][math][founditems][commission]+[/founditems]0[/math][/search]Once the search hits about the 130-135th record the total which should looklike: 79924.24 instead gets formatted as 79924.2399999999. I've zappedgremlins, reloaded the database, changed the startat value, verified thatall values are integers (all are formatted x.xx ), even modified thecontents of the records with different values and still the computed valuegets formatted as .xx99999999.As a further test I created a test db and wrote out the commission valuesfrom the problem db to the test db and the results are the same - althoughthe problem begins at the 125th record - *does not* appear in the 126threcord but comes back at the 127th record. What the heck is going on here?Running 3.04PI w/Web* 4.0 on a G4 w/OS 8.6ThanksMarty Schmid-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Marty Schmid
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:
Appending problem (still) on Solaris (2000)
Database changes (1998)
Is this possible, WebCat2.0 and checkboxes (1997)
showif errors (1998)
Single Link browsing (1997)
File dates in WebCatalog .tmpl/.inc (1997)
Going to anchors within a template page (1997)
HTML Editors (1997)
PCS Frames (1997)
[WebDNA] agree? --> also broken when we compare against something with a "!" in it. (2009)
Forcing Search w/ URL (1999)
EMail not being sent (1999)
WYSIWYG Entry of text fields (2001)
Quitting WebMerchant ? (1997)
Need some Java Script Code (2003)
Items XX to XX shown (1997)
Under Score (1999)
Re:no [search] with NT (1997)
[trim]?! (2004)
Support ?? (1997)