Re: REPOST [SUM field=xxxx]
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 32913
interpreted = N
texte = > > >>[SEARCH DB=^db/somedb.db&neSKUdatarq=0&max=475] >> [SUM field=price] >>[/SEARCH] >> causes webstar 4.2 to quit, but when I accomplis the same effect >>using a founditems loop and math, it works just fine. > >I can't duplicate this on MacOS with 4.0 plugin. Is it working for you now? > >Grant Hulbert, Director of Engineering **********************************Nope, it's still broken.1) Create test.db with one field called PRICE. 2) Populate the db with 52 records with 11.1 in each record 3) Execute a page with this search:[SEARCH DB=test.db&nePRICEdatarq=[blank]] SUM=[SUM field=price] [/SEARCH]4) BoomRemove the 52nd record and it will work.Add any number of integers and it will work (summing 52 lines of value 11 works).Add a certain number of floating point numbers (it was around 94 records if the value was 1.1) and Webstar crashes.Even when webcat didn't crash on some of the larger floating point record calculations, the sum returned on the page was not accurate.This is using 4.0 release plugin on Webstar 4.2.-Dale -- Dale LaFountain Vice President of Information Technology, WebMaster Dark Horse Comics, Inc. mailto:dalel@darkhorse.com Phone: 503-652-8815 x324 http://www.darkhorse.com/############################################################# 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 To switch to the INDEX mode, E-mail to Send administrative queries to
Associated Messages, from the most recent to the oldest:
> > >>[SEARCH DB=^db/somedb.db&neSKUdatarq=0&max=475] >> [SUM field=price] >>[/SEARCH] >> causes webstar 4.2 to quit, but when I accomplis the same effect >>using a founditems loop and math, it works just fine. > >I can't duplicate this on MacOS with 4.0 plugin. Is it working for you now? > >Grant Hulbert, Director of Engineering **********************************Nope, it's still broken.1) Create test.db with one field called PRICE. 2) Populate the db with 52 records with 11.1 in each record 3) Execute a page with this search:[SEARCH DB=test.db&nePRICEdatarq=[blank]] SUM=[SUM field=price] [/SEARCH]4) BoomRemove the 52nd record and it will work.Add any number of integers and it will work (summing 52 lines of value 11 works).Add a certain number of floating point numbers (it was around 94 records if the value was 1.1) and Webstar crashes.Even when webcat didn't crash on some of the larger floating point record calculations, the sum returned on the page was not accurate.This is using 4.0 release plugin on Webstar 4.2.-Dale -- Dale LaFountain Vice President of Information Technology, WebMaster Dark Horse Comics, Inc. mailto:dalel@darkhorse.com Phone: 503-652-8815 x324 http://www.darkhorse.com/############################################################# 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 To switch to the INDEX mode, E-mail to Send administrative queries to
Dale LaFountain
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:
WebCat2 several catalogs? (1997)
WebDNA Solutions ... (1997)
nslookup (2000)
back button loses cart (2000)
Tech support (2000)
[WebDNA] for a rainy day.. if ever/when the hood is up again on the [function]/[return] code (2011)
Hiding HTML and page breaks (1997)
cookies ok ??? (2006)
RE: Can a database get stomped by simultaneous access? (1997)
Database Structure? (1998)
Math with Time (1997)
Hiding usernames and passwords in URL (1998)
free zip codes database (1999)
Rhapsody? (1997)
Deleting Orders (1997)
[random] only for 1-100??? (1997)
[subtotal] (2000)
Moment of Thanks (1997)
Hiding HTML and breaking the page (1997)
fun with shell scripting (2003)