Re: Field Totals

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58275
interpreted = N
texte = I new there had to be something - Thanks I'm off home now. Cheers ======================================== Steve Craig - Asylum Interactive Ltd Tel +44 1224 642960 Fax +44 1224 642962 ======================================== http://www.asylumweb.com Email: steve@asylumweb.com ======================================== > From: "Dan Strong" > Reply-To: (WebDNA Talk) > Date: Wed, 09 Jun 2004 11:59:23 -0700 > To: (WebDNA Talk) > Subject: Re: Field Totals > > [search db=your.db&eqUSERdata=[user]][Sum field=HOURS][/search] > -Dan > > > On Wed, 09 Jun 2004 19:47:32 +0100 > Steve Craig wrote: >> Hi >> >> It's that dreaded brain fade time again! >> >> If I have a database that has fields similar to... >> >> USER PROJECT HOURS >> >> ...where HOURS is a number. >> >> Is there a TOTAL command that I can add to the search command so I can do a >> search on a given USER and total his hours column without having to go into >> a loop adding each iteration to a new variable etc? >> >> Hope this is clear. >> >> Cheers >> ======================================== >> Steve Craig - Asylum Interactive Ltd >> Tel +44 1224 642960 Fax +44 1224 642962 >> ======================================== >> http://www.asylumweb.com >> Email: steve@asylumweb.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://webdna.smithmicro.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://webdna.smithmicro.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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Field Totals ( Gary Krockover 2004)
  2. Re: Field Totals ( Terry Wilson 2004)
  3. Re: Field Totals ( Donovan Brooke 2004)
  4. Re: Field Totals ( Gary Krockover 2004)
  5. Re: Field Totals ( Chris 2004)
  6. Re: Field Totals ( Gary Krockover 2004)
  7. Re: Field Totals ( "Dan Strong" 2004)
  8. Re: Field Totals ( Steve Craig 2004)
  9. Re: Field Totals ( "Dan Strong" 2004)
  10. Field Totals ( Steve Craig 2004)
I new there had to be something - Thanks I'm off home now. Cheers ======================================== Steve Craig - Asylum Interactive Ltd Tel +44 1224 642960 Fax +44 1224 642962 ======================================== http://www.asylumweb.com Email: steve@asylumweb.com ======================================== > From: "Dan Strong" > Reply-To: (WebDNA Talk) > Date: Wed, 09 Jun 2004 11:59:23 -0700 > To: (WebDNA Talk) > Subject: Re: Field Totals > > [search db=your.db&eqUSERdata=[user]][Sum field=HOURS][/search] > -Dan > > > On Wed, 09 Jun 2004 19:47:32 +0100 > Steve Craig wrote: >> Hi >> >> It's that dreaded brain fade time again! >> >> If I have a database that has fields similar to... >> >> USER PROJECT HOURS >> >> ...where HOURS is a number. >> >> Is there a TOTAL command that I can add to the search command so I can do a >> search on a given USER and total his hours column without having to go into >> a loop adding each iteration to a new variable etc? >> >> Hope this is clear. >> >> Cheers >> ======================================== >> Steve Craig - Asylum Interactive Ltd >> Tel +44 1224 642960 Fax +44 1224 642962 >> ======================================== >> http://www.asylumweb.com >> Email: steve@asylumweb.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://webdna.smithmicro.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://webdna.smithmicro.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://webdna.smithmicro.com/ Steve Craig

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:

[AppendFile] problem (WebCat2b13 Mac .acgi) (1997) Does not begin with.... (2003) Linux -> OS X (2002) Comparing two fields so the match (1998) Checking for pre-existing passwords (1998) Upgrading old WebCat Database Files (1997) Why won't Netscape... (2000) Fun with Dates - finally resolved but.... (1997) Date Math (2005) Authenticate Checker - different versions ?? (1998) db access problem after switching to SSL (2001) [WebDNA] macOS High Sierra (2017) What is the maximum record length? (1998) show all problem (1997) Bug or syntax error on my part? (1997) Bannerad Demo (1998) show all problem (1997) webcat NT (1998) Replace context problem ... and answers (1997) WebCat2b13MacPlugIn - syntax to convert date (1997)