Summing a field full of numbers ...

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 10778
interpreted = N
texte = Hi Grant,I thought you'd like to know that when I put the following syntax into a template that searches thru a 16,000 record database, the math does *not* choke on the very long string of number it has to add to get the results. You mentioned earlier that the [math] might not be able to handle such a long calculation, but it does just fine![search db=listings.db&nepricedata=0] [format thousands .1f] [math] ([founditems][price]+[/founditems]0)/1000000 [/math] [/format] [/search]This WebDNA takes about 22 seconds to get the results, so it's not a fast response ... but remember, it's adding 16,000 number, each of which has six figures.I'm not going to have WebCat2 calculate this everytime someone looks at the page, but I would like to calculate this number once a day so I can store the value in a database, then it will take only a fraction of a second to retrieve that value with a lookup ... :)Sincerely, Ken Associated Messages, from the most recent to the oldest:

    
Hi Grant,I thought you'd like to know that when I put the following syntax into a template that searches thru a 16,000 record database, the math does *not* choke on the very long string of number it has to add to get the results. You mentioned earlier that the [math] might not be able to handle such a long calculation, but it does just fine![search db=listings.db&nepricedata=0] [format thousands .1f] [math] ([founditems][price]+[/founditems]0)/1000000 [/math] [/format] [/search]This WebDNA takes about 22 seconds to get the results, so it's not a fast response ... but remember, it's adding 16,000 number, each of which has six figures.I'm not going to have WebCat2 calculate this everytime someone looks at the page, but I would like to calculate this number once a day so I can store the value in a database, then it will take only a fraction of a second to retrieve that value with a lookup ... :)Sincerely, Ken 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:

Replacing entry (1998) 2 easy questions re: [showif] and [sendmail] (1997) WebCatalog Features (1997) [WebDNA] Google like search (2016) Anyone awake? Newby moves deeper! Sitesearch & Customer DB Append Context or Command? (2000) 100% cpu load (2006) Secured Order Forms (1998) OH CRAP!!!!!- Template not found error!!! (1999) WebCat2.0 [format thousands .0f] no go (1997) Off Topic: Frames Killer? (1998) [switch] platform specific bug??? (2003) Summing fields (1997) Sites that use WebDNA (2003) Problem using # in my field names ... (1998) nested ListWords? (2003) shipping costs (1997) [isfile] ? (1997) View Source from cache (1997) Fufillment e-mail? (1998) How to include weather (2000)