Summing fields in a search/founditems context??

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 36381
interpreted = N
texte = Would one of you whiz kids let me in on how to get a sum total of a particular field in a founditems set.Let's say I've got a db with two fields, name and age. I want to do a search for all unique names, and then add up all the ages to yield a total age result.Bob 10 Joe 12 Nancy 13Total Age: 35Help??!Thanks!________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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 Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Summing fields in a search/founditems context?? (Jason Tyler 2000)
  2. Summing fields in a search/founditems context?? (Robert McPeak 2000)
Would one of you whiz kids let me in on how to get a sum total of a particular field in a founditems set.Let's say I've got a db with two fields, name and age. I want to do a search for all unique names, and then add up all the ages to yield a total age result.Bob 10 Joe 12 Nancy 13Total Age: 35Help??!Thanks!________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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 Web Archive of this list is at: http://search.smithmicro.com/ Robert McPeak

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:

Formatting date to number (2000) How to put the Trademark Symbol (%99) in Sendmail? (2003) DB Emergency (2002) Help name our technology! (1997) WebCatalog dying in NT (1998) Formatting dates stored in db (2003) max page views Mac can handle (1999) Errata: WCS Newbie question (1997) Force a search at the default.tmpl page? (1997) New 4.5 installer (2002) all records returned. (1997) Re requiredFields parameter (1998) [sql] problems in WebCat 4.0 (2000) Sami (1998) WebDNA for Dummies (2003) [WebDNA] writing pdfs on the fly (Avery labels #5160) (2010) a * question (2003) WC Database Format (1997) Saving/Looking Up customer numbers (1998) Dummy Credit Card Number for debug? (1997)