Re: Math Bug
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 25447
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? This sounds like a problem for webcatalog@smithmicro.com ... :)================================ Kenneth Grome, WebDNA Consultant 808-737-6499, http://webdna.net ================================------------------------------------------------------------- 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? This sounds like a problem for webcatalog@smithmicro.com ... :)================================ Kenneth Grome, WebDNA Consultant 808-737-6499, http://webdna.net ================================------------------------------------------------------------- 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
Kenneth Grome
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:
[WebDNA] Can't write to a db when working on on a iMac (2019)
WebCatalog Features (1997)
OT Comcast high speed internet issues (2005)
can WC render sites out? (1997)
accountnum using [listwords] (2001)
carriage returns in data (1997)
Re:WebCatalog/WebMerchant III (1998)
group searching problem (2002)
Formatting date to number (2000)
[WebDNA] WebDNA hosting for $10 a month (2010)
Single Link browsing (1997)
Hideifs / Showifs (2000)
RE: Formulas.db + Users.db (1997)
WebCat2b12 Mac.acgi--[searchstring] bug (1997)
How do I get Google to crawl a WebCat site? (2003)
[append] (1997)
[Semi-OT] Eaaaaaasy OSX FTP (2003)
Webcatalog [blank] Problem (1999)
price totals (2003)
Dual 2GHz G5 (2003)