Re: Summing fields
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 10810
interpreted = N
texte = Kenneth Grome wrote:> > >> >I think it was mentioned once that it is possible to calculate a total> >> >for a particular field over records in a database. What is the syntax> >> >for doing this?> >>> >> <--starts a total variable at 0> >> [FoundItems]> >> > >> [/FoundItems]> >>> >> If you view source you will see this generates a lot of HTML comments> >>like with the intermediate results. You might also try> >>> >> [math]total=[FoundItems][field]+[/FoundItems]0[/math]> >>> >> This generates a single math equation that looks like total=5+9+4+49+7+96+0> > >Apparently both methods work cause I see the 's. The second> >displayed the total as I wanted. How would I get the total to display> >using the first method?> > If you remove the that surround the [math] context, it will> display all those intermediate totals. But if you want to display the grand> total instead of the intermediate totals, you have to use the second> formula, or ...> > I created some WebDNA code using a separate database to calculate the total> just once per day. This allows me to retrieve the total from the database> instead of recalculating it every time. If you want my code, just send me> private email and ask ... :)> > Sincerely,> KenI discovered a good way for me: variables such as total only make sensewithin a [math] context, so then I want to 'print' the total -- outsidethe [foundItems]...[/foundItems] loop, I express it as[math]total[/math]. That works quite well. I am doing this so that I can allow people to shop and select itemswithout going to the shopping cart. As soon as I get it all completed,I will share the templates.Dean Smith
Associated Messages, from the most recent to the oldest:
Kenneth Grome wrote:> > >> >I think it was mentioned once that it is possible to calculate a total> >> >for a particular field over records in a database. What is the syntax> >> >for doing this?> >>> >> [math]total=0[/math]> <--starts a total variable at 0> >>
[founditems]> >> [math]total=total+[field][/math]>> >> [/FoundItems]> >>> >> If you view source you will see this generates a lot of HTML comments> >>like with the intermediate results. You might also try> >>> >>
[math]total=
[founditems][field]+[/FoundItems]0[/math]> >>> >> This generates a single math equation that looks like total=5+9+4+49+7+96+0> > >Apparently both methods work cause I see the 's. The second> >displayed the total as I wanted. How would I get the total to display> >using the first method?> > If you remove the that surround the
[math] context, it will> display all those intermediate totals. But if you want to display the grand> total instead of the intermediate totals, you have to use the second> formula, or ...> > I created some WebDNA code using a separate database to calculate the total> just once per day. This allows me to retrieve the total from the database> instead of recalculating it every time. If you want my code, just send me> private email and ask ... :)> > Sincerely,> KenI discovered a good way for me: variables such as total only make sensewithin a
[math] context, so then I want to 'print' the total -- outsidethe
[founditems]...[/foundItems] loop, I express it as
[math]total[/math]. That works quite well. I am doing this so that I can allow people to shop and select itemswithout going to the shopping cart. As soon as I get it all completed,I will share the templates.Dean Smith
Dean Smith
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] Off topic: ImageMagick (2008)
Possible Bug in 2.0b15.acgi (1997)
Include a big block of text (1997)
All questions are welcome on this list (1997)
Multiple prices (1997)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
Template Not Found (1998)
[WebDNA] How to test email validity? (2011)
Date search - yes or no (1997)
More news on 5.0 (2003)
Databases inside [SHOWIF] (1998)
Storing dates (was: Ticket Ordering Question) (2003)
RE: extended ASCII with middle command (1999)
WebCat for Unix?? (1997)
Question about links (1999)
Location of Browser Info.txt file (1997)
Multi-Row Tables from a search. (1997)
too many nested [xxx] (1997)
Passing Cart variable to subdirectory files? (1997)
Using [showif] within [lineitems] [code fragment] (2000)