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 syntaxinto a template that searches thru a 16,000 record database, the mathdoes *not* choke on the very long string of number it has to add toget the results. You mentioned earlier that the [math] might not beable 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 afast response ... but remember, it's adding 16,000 number, each ofwhich has six figures.I'm not going to have WebCat2 calculate this everytime someone looksat the page, but I would like to calculate this number once a day soI can store the value in a database, then it will take only afraction of a second to retrieve that value with a lookup ... :)Sincerely,Ken
Associated Messages, from the most recent to the oldest:
|
- Summing a field full of numbers ... (Kenneth Grome 1997)
|
Hi Grant,I thought you'd like to know that when I put the following syntaxinto a template that searches thru a 16,000 record database, the mathdoes *not* choke on the very long string of number it has to add toget the results. You mentioned earlier that the
[math] might not beable 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 afast response ... but remember, it's adding 16,000 number, each ofwhich has six figures.I'm not going to have WebCat2 calculate this everytime someone looksat the page, but I would like to calculate this number once a day soI can store the value in a database, then it will take only afraction 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:
Not really WebCat (1997)
hmmm (2006)
Nested vs conditional (1997)
problems with 2 tags (1997)
Multi Actions (1999)
Problem with updating 2.1b7 -> 2.1.1 (1998)
How many Databases can I open? (2003)
Make sure I understand this??? (1997)
[WebDNA] WebDNA developer (2008)
Founditems context returning only 1 item (1997)
show all problem (1997)
[WebDNA] Anyone used these people ? (2010)
webmerch and serials - almost there (1997)
[OT] Web Site Mapping Software (2000)
Date comparison using showif (2003)
Am I going senile? (Price recalc based on quantity) (1997)
Search returns all, not 20 (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Softball questions (2003)
Keep away (1997)