Re: [Sum] function?
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 11095
interpreted = N
texte = > >Using the [math]...[/math] context, or even not using it, is there any> >way to get the grand total of the numeric field of a .db file? In other> >words, if I have a database with a field for total and records of> >234.95, 221.35, 19.95, 23.95, etc. can I somehow total them up? > > Ken Grome has kindly put a nice WebDNA sample up on ftp://robin.smithmicro.com/pub in the Customer Solutions folder. It does summing and some sophisticated caching of results to speed later requests.Sounds like just what I need. Unfortunately, I'm having problemsde-BinHexing the archive; it appears that a couple of the solutions arenot encoded properly. If Ken is listening, could you possibly e-mailDaily Totals to me directly? Thanks a bunch.-- Gil Poulsen, Webmaster*************************************************************** AltiM@c * Phone: (908) 469-2567 ** 126 Jerome Avenue * FAX: (908) 469-5823 ** South Bound Brook, NJ * e-mail: help@altimac.com ** 08880-1111 * WWW: http://www.altimac.com ***************************************************************
Associated Messages, from the most recent to the oldest:
> >Using the
[math]...[/math] context, or even not using it, is there any> >way to get the grand total of the numeric field of a .db file? In other> >words, if I have a database with a field for total and records of> >234.95, 221.35, 19.95, 23.95, etc. can I somehow total them up? > > Ken Grome has kindly put a nice WebDNA sample up on ftp://robin.smithmicro.com/pub in the Customer Solutions folder. It does summing and some sophisticated caching of results to speed later requests.Sounds like just what I need. Unfortunately, I'm having problemsde-BinHexing the archive; it appears that a couple of the solutions arenot encoded properly. If Ken is listening, could you possibly e-mailDaily Totals to me directly? Thanks a bunch.-- Gil Poulsen, Webmaster*************************************************************** AltiM@c * Phone: (908) 469-2567 ** 126 Jerome Avenue * FAX: (908) 469-5823 ** South Bound Brook, NJ * e-mail: help@altimac.com ** 08880-1111 * 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:
Search in 2 or more catalogs (1997)
NT - Thanks and Taxes (1997)
reporting commands (2001)
Pull Down Search (2000)
Email template names (1997)
[WebDNA] Security best practice (2009)
SetHeader not Working (2006)
RE: Displaying Location (1997)
Table sorting by selected category then others (2004)
Possible Shownext from Listfiles???? (2000)
b12 cannot limit records returned and more. (1997)
& in Lookups (1997)
Multiple Items (2004)
For those of you not on the WebCatalog Beta... (1997)
What am I missing (1997)
[convertchars] Problem (2000)
[OT] Backup/ failsafe strategies (2003)
'does not contain' operator needed ... (1997)
WebCatalog on Solaris? (2000)
Running 2 two WebCatalog.acgi's (1996)