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:
Problem (1997)
Checkboxes on forms?? (1998)
Apache 2.0 incompatible? (2005)
Display [price] in banner ad (1998)
Where is f2? (1997)
problems with 2 tags shakur (1997)
Artwork (1997)
Help! WebCat2 bug (1997)
Execute Applescript (1997)
assigning a id no. (2000)
Extended [ConvertChars] (1997)
Formula Question (1998)
cybercash on OSX - was Executing remote AppleScript (2000)
[WebDNA] CSV Import Template (2010)
WebCatalog can't find database (1997)
[WebDNA] Admin Login Required to Serve any TPL Page (2009)
Sort Order on a page search (1997)
WebMerchant 3.0 for Mac shipping now (1998)
WebCat2b13 Command Reference Doc error (1997)
[include] affect on filepaths for links? (1997)