Re: Field Totals

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58276
interpreted = N
texte = You're welcome. I learned that little trick from Mr. Krockover. -Dan On Wed, 09 Jun 2004 19:59:47 +0100 Steve Craig wrote: >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/ ------------------------------------------------------------- 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)
You're welcome. I learned that little trick from Mr. Krockover. -Dan On Wed, 09 Jun 2004 19:59:47 +0100 Steve Craig wrote: >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/ ------------------------------------------------------------- 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/ "Dan Strong"

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:

Nesting Search Within Tag? (1997) PCS Frames-Default page is solution! (1997) type 2 errors with ssl server (1997) Help! WebCat2 bug (1997) Round up prices (2000) 4.51 Triggers (2003) WebCatalog2 Feature Feedback (1996) checkbox results written to a database (1999) WebMerchant 3.0 for Mac shipping now (1998) Mail Service Dead (1998) Custom Tags or Modular Code (2001) Next (1997) Another question (1997) ReadDateFormat bug in 3.0.1 (1998) complete escaped ascii chart - importing and exporting files question (1998) combine search (1998) WebDNA 6 (2004) Introduction/Tutorial/QuickStart (1997) Do triggers work on Macs? (2000) sorting by date (1999)