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:
100% CPU on NT (2001)
Size limit for tmpl editor ? (1997)
Need help with emailer- 2 issues (1997)
How to append text after the sign & (1997)
Max Record length restated as maybe bug (1997)
NT vs Mac (1997)
Multiple prices (1997)
Discount solution? (1998)
Running a store on BOTH http and https (1998)
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
Country & Ship-to address & other fields ? (1997)
Forms Search Questions (1997)
RAM variables (1997)
For those of you not on the WebCatalog Beta... (1997)
Re:trouble (1997)
Opinion Poll Please (2002)
[WebDNA] Optimizing for speed (2010)
Great product and great job ! (1997)
Firesite cache vs webcat cache (1997)
[OT] Stock price charts (2006)