Re: Me know logical no need
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 41310
interpreted = N
texte = Would it be possible for you to add a field to the database that would keep a running total for each realtor. Every time a listing is added you look at the last running_total field in the listing for that agent, then add the cost of the new one to that total and stick it in the new listing's field. Since all the entries are added into the database chronologically, it would then be simple to do a summarized agentID search by most recent date to figure out who has the highest running_total. You could total up each agents entries as of now, and enter that into the last entries running_total field for that agent. No need to go back and do the math for each entry, since all you need is a total, then the script would take care of it from here.Just a thought... RWAndrew Simpson wrote:> Do you have SQL Server handy??? > > Wouldn't try this in webcat > > On 10/7/02 11:49 AM, Aaron Lynch
wrote: > > > I need some advice on the best way to approach this task, I just can't seem > > to wrap my tiny mind around the concepts needed... > > > > > > I have a large real estate DB, currently 35 megs but when this project is > > done it will be 500 Megs in size. (every house sold in Seattle for a year) > > > > I want to find the top 20 listing agents, so for example, the db looks > > something like: > > > > AgentID price > > AgentID price > > AgentID price > > > > I think to find the agents with the most actual listings would be easy using > > allhit=1&max=20 (right?) > > > > 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. > > > > > > ------------------------------------------------------------- > > 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/ > > -- > > Andrew Simpson > Web Development > > Blackpepper Interactive Ltd > PO Box 99805 > Newmarket > > 4 Clayton Street > Newmarket > Auckland > > Ph: +64 9 520-6281 > Mob: 0272733270 > Fax: +64 9 524-1849 > > http://www.blackpepper.co.nz > > ------------------------------------------------------------- > 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/--================================================ Robert Wade Outbound Creative, Inc. robert@outboundcreative.com ================================================ |[ ] L|| ‘||‘ ||} |[ ] L|| ||\| ||) ================================================------------------------------------------------------------- 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:
Would it be possible for you to add a field to the database that would keep a running total for each realtor. Every time a listing is added you look at the last running_total field in the listing for that agent, then add the cost of the new one to that total and stick it in the new listing's field. Since all the entries are added into the database chronologically, it would then be simple to do a summarized agentID search by most recent date to figure out who has the highest running_total. You could total up each agents entries as of now, and enter that into the last entries running_total field for that agent. No need to go back and do the math for each entry, since all you need is a total, then the script would take care of it from here.Just a thought... RWAndrew Simpson wrote:> Do you have SQL Server handy??? > > Wouldn't try this in webcat > > On 10/7/02 11:49 AM, Aaron Lynch wrote: > > > I need some advice on the best way to approach this task, I just can't seem > > to wrap my tiny mind around the concepts needed... > > > > > > I have a large real estate DB, currently 35 megs but when this project is > > done it will be 500 Megs in size. (every house sold in Seattle for a year) > > > > I want to find the top 20 listing agents, so for example, the db looks > > something like: > > > > AgentID price > > AgentID price > > AgentID price > > > > I think to find the agents with the most actual listings would be easy using > > allhit=1&max=20 (right?) > > > > 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. > > > > > > ------------------------------------------------------------- > > 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/ > > -- > > Andrew Simpson > Web Development > > Blackpepper Interactive Ltd > PO Box 99805 > Newmarket > > 4 Clayton Street > Newmarket > Auckland > > Ph: +64 9 520-6281 > Mob: 0272733270 > Fax: +64 9 524-1849 > > http://www.blackpepper.co.nz > > ------------------------------------------------------------- > 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/--================================================ Robert Wade Outbound Creative, Inc. robert@outboundcreative.com ================================================ |[ ] L|| ‘||‘ ||} |[ ] L|| ||\| ||) ================================================------------------------------------------------------------- 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/
Robert Wade
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:
OK, my turn... TEST (2003)
webten vs. webstar (1998)
Testing the WebCat Email List Members (2000)
WebCat2b12plugin - [search] is broken ... not! (1997)
Some Advise needed (1997)
Bug Report, maybe (1997)
Shopping with Accounts (2003)
Updating a database once per day - An example (1998)
Sort Order on a page search (1997)
WebTrends (2002)
NT vs Mac (1997)
WebCatalog not running after upgrade (2000)
Re:quit command on NT (1997)
Make sure I understand this??? (1997)
Convert from WebDNA to PHP/MySQL (2006)
Copyright that puppy (1998)
any limitations on # of users.db entries (1999)
Access Denied! But why? (1997)
Protect (1997)
dates and hex formatting (1997)