Re: Me know logical no need
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 41309
interpreted = N
texte = > but, to find who has the most dollar volume, do I need to search all> listings, summarize all the agents, search all the agents, do math into a> temp DB to get a total, and then search the temp DB by total? or is there> (please dear god) an easier way? the full db will be several hundred> thousand records, each 130 or so fields wide.You could search and do a summ=T on the agentsThen search again for those agents and total the price ..New in 4.0[Sum field=fieldName]Calculates the numerical sum of all the found records, using the fieldNamecolumn.Sort of .. [search for agent][sum field=price][/search]Oh yeh .. And I would trigger this to run at 1AM or so .. Not liveAlain-------------------------------------------------------------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:
> but, to find who has the most dollar volume, do I need to search all> listings, summarize all the agents, search all the agents, do math into a> temp DB to get a total, and then search the temp DB by total? or is there> (please dear god) an easier way? the full db will be several hundred> thousand records, each 130 or so fields wide.You could search and do a summ=T on the agentsThen search again for those agents and total the price ..New in 4.0[Sum field=fieldName]Calculates the numerical sum of all the found records, using the fieldNamecolumn.Sort of .. [search for agent][sum field=price][/search]Oh yeh .. And I would trigger this to run at 1AM or so .. Not liveAlain-------------------------------------------------------------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/
Alain Russell
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:
Date Formats (1997)
[CART] (1997)
[WebDNA] Installing with MAMP (2015)
Re:no template caching (1997)
WebCat2b13MacPlugIn - More limits on [include] (1997)
What am I missing (1997)
RE: Displaying Location (1997)
Dark Horse Comics success story (1997)
Multiple prices (1997)
Notepad problems (1998)
Robert Minor duplicate mail (1997)
WebCat2.0 [format thousands .0f] no go (1997)
WebCat2 - Getting to the browser's username/password data (1997)
format and math on the fly (1998)
Problems passing [SKU] with $Replace in 2.0 (1997)
Showif dates... (2002)
Best way to handle 404 errors with WebDNA and Web* V (2003)
Secure server question (1997)
Re1000001: Setting up shop (1997)
[WebDNA] webdna site down? (2011)