Running subtotal?

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 18370
interpreted = N
texte = Here's one that's way beyond my mortal abilities. I am trying to insert a running subtotal into a [foundItems] context that breaks at each date change and totals the hours for each date. The search at the bottom is hard-coded to return results for 6/12 just as a test. Anyway, since this output will encompass two weeks, perhaps three, of data, I cannot come up with a way to handle a running subtotal short of doing 14 separate [search] and [founditems] contexts, one for each date, and then 14 more for the running subtotals. Any insights would be much appreciated. (Note that I've adopted Ken's date storage and retrieval method here, which I highly recommend.) [search db=hours.db&equserdata=[username]&aswdatesort=1&max=500] [foundItems] [format days_to_date %a][wdate][/format]., [format days_to_date][wdate][/format][ccode] [lookup db=codes.db&lookinField=ccode&value=[ccode]&returnField=desc][whours] [/foundItems] Total hours for 06/12/1998: [search db=hours.db&equserdatarq=[username]&eqwdatedatarq=729917][math][founditems][whours]+[/founditems]0[/math][/search] -- Gil Poulsen, Webmaster************************************************************** * AltiM@c * Phone: (908) 222-9001 * * 111 Mali Drive * FAX: (908) 222-9002 * * North Plainfield, NJ * e-mail: help@altimac.com * * 07062-2355 * WWW: http://www.altimac.com * ************************************************************** Associated Messages, from the most recent to the oldest:

    
Here's one that's way beyond my mortal abilities. I am trying to insert a running subtotal into a [founditems] context that breaks at each date change and totals the hours for each date. The search at the bottom is hard-coded to return results for 6/12 just as a test. Anyway, since this output will encompass two weeks, perhaps three, of data, I cannot come up with a way to handle a running subtotal short of doing 14 separate [search] and [founditems] contexts, one for each date, and then 14 more for the running subtotals. Any insights would be much appreciated. (Note that I've adopted Ken's date storage and retrieval method here, which I highly recommend.) [search db=hours.db&equserdata=[username]&aswdatesort=1&max=500] [founditems] [format days_to_date %a][wdate][/format]., [format days_to_date][wdate][/format][ccode] [lookup db=codes.db&lookinField=ccode&value=[ccode]&returnField=desc][whours] [/foundItems] Total hours for 06/12/1998: [search db=hours.db&equserdatarq=[username]&eqwdatedatarq=729917][math][founditems][whours]+[/founditems]0[/math][/search] -- Gil Poulsen, Webmaster************************************************************** * AltiM@c * Phone: (908) 222-9001 * * 111 Mali Drive * FAX: (908) 222-9002 * * North Plainfield, NJ * e-mail: help@altimac.com * * 07062-2355 * WWW: http://www.altimac.com * ************************************************************** Gil Poulsen

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:

Separate SSL Server (1997) Cookies (1999) Limiting user access to .tmpl files (1997) bug in [SendMail] (1997) emailer cc to figured out (1997) Thanks ! (1997) 'page impression' techniques for banner ads (1999) [Announce] Newest Commerce Site based on WebCatalog (1997) Join us at MacWorld! - Part 2 (1998) [include] affect on filepaths for links? (1997) re:check boxes (1997) URGENT! Locked DB's (2001) Queertrons? (1997) Next (1997) FW: Username and password in tcp connect/send (2001) I try hard to think positively (1998) Problem with Midnight (2003) External Images (1998) Bug or syntax error on my part? (1997) Country & Ship-to address & other fields ? (1997)