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 using this technique: [some search context] [math][founditems][commission]+[/founditems]0[/math] [/search]Once the search hits about the 130-135th record the total which should look like: 79924.24 instead gets formatted as 79924.2399999999. I've zapped gremlins, reloaded the database, changed the startat value, verified that all values are integers (all are formatted x.xx ), even modified the contents of the records with different values and still the computed value gets formatted as .xx99999999.As a further test I created a test db and wrote out the commission values from the problem db to the test db and the results are the same - although the problem begins at the 125th record - *does not* appear in the 126th record 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.6 Thanks Marty 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 using this technique: [some search context] [math][founditems][commission]+[/founditems]0[/math] [/search]Once the search hits about the 130-135th record the total which should look like: 79924.24 instead gets formatted as 79924.2399999999. I've zapped gremlins, reloaded the database, changed the startat value, verified that all values are integers (all are formatted x.xx ), even modified the contents of the records with different values and still the computed value gets formatted as .xx99999999.As a further test I created a test db and wrote out the commission values from the problem db to the test db and the results are the same - although the problem begins at the 125th record - *does not* appear in the 126th record 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.6 Thanks Marty 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:

ignore this test (1999) Slightly [OT] - Finding host names (1999) WebCat Error Log problem (2.0.1, acgi, Mac) (1997) Sendmail Enigma (2004) WebCat2 Append problem (B14Macacgi) (1997) Founditems Add/remove graphic display problem (1999) [HIDEIF] inside [FOUNDITEM] (1997) Using Applescript to process WebCatalog functions (1998) Polls (2003) Running _every_ page through WebCat ? (1997) wierd [cart] action! (1997) WCS Newbie question (1997) Line items in table cells (1997) Is there an easier way? (1998) can we get string variables? (1998) WebCat2 Append problem (B14Macacgi) (1997) Multiple prices (1997) Nesting format tags (1997) Random sort is not random at all..... (2000) [WebDNA] TCPconnect code snippet needed (2008)