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 agents Then 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 fieldName column.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:

    
  1. Re: SOLUTION? Re: Me know logical no need (John Peacock 2002)
  2. Re: SOLUTION? Re: Me know logical no need (Jesse Williams-Proudman 2002)
  3. Re: SOLUTION? Re: Me know logical no need (John Peacock 2002)
  4. Re: SOLUTION? Re: Me know logical no need (Brian Fries 2002)
  5. SOLUTION? Re: Me know logical no need (Joseph D'Andrea 2002)
  6. Re: Me know logical no need (Dan Strong 2002)
  7. Re: Me know logical no need (Michael Davis 2002)
  8. Re: Me know logical no need (Aaron Lynch 2002)
  9. Re: Me know logical no need (Michael Davis 2002)
  10. Re: Me know logical no need Now totally OT (Aaron Lynch 2002)
  11. Re: Me know logical no need (Glenn Busbin 2002)
  12. Re: Me know logical no need (Aaron Lynch 2002)
  13. Re: Me know logical no need (Andrew Simpson 2002)
  14. Re: Me know logical no need (Alain Russell 2002)
  15. Re: Me know logical no need (Kenneth Grome 2002)
  16. Re: Me know logical no need (Aaron Lynch 2002)
  17. Re: Me know logical no need (Andrew Simpson 2002)
  18. Re: Me know logical no need (Aaron Lynch 2002)
  19. Re: Me know logical no need (Glenn Busbin 2002)
  20. Re: Me know logical no need (Aaron Lynch 2002)
  21. Re: Me know logical no need (Andrew Simpson 2002)
  22. Re: Me know logical no need (Kenneth Grome 2002)
  23. Re: Me know logical no need (Kenneth Grome 2002)
  24. Re: Me know logical no need (Aaron Lynch 2002)
  25. Re: Me know logical no need (Stuart Tremain 2002)
  26. Re: Me know logical no need (Aaron Lynch 2002)
  27. Re: Me know logical no need (Aaron Lynch 2002)
  28. Re: Me know logical no need (Jesse Williams-Proudman 2002)
  29. Re: Me know logical no need (Jesse Williams-Proudman 2002)
  30. Re: Me know logical no need (Alain Russell 2002)
  31. Re: Me know logical no need (Glenn Busbin 2002)
  32. Re: Me know logical no need (Aaron Lynch 2002)
  33. Re: Me know logical no need (Stuart Tremain 2002)
  34. Re: Me know logical no need (Robert Wade 2002)
  35. Re: Me know logical no need (Alain Russell 2002)
  36. Re: Me know logical no need (Andrew Simpson 2002)
  37. Me know logical no need (Aaron Lynch 2002)
> 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 agents Then 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 fieldName column.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)