Re: Sorting nested search

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 49025
interpreted = N
texte = Will, write out a temperary database that contains the amount (frequency) and then do a search with a frequency sort to display....This is a great use for the new [table] tag in 5.0. ;-)DonovanWJ Starck wrote:> This search displays results of a visitors log given an entered date > range: > > [search > db=../dbs/ > sitetrack.db&group1field=accessdate&group2field=accessdate&gegroup1datar > q=[startdate]&legroup2datarq=[enddate]&ipaddresssumm=T&ipaddresssort=1] > > [founditems] > > count=[search > db=../dbs/sitetrack.db&eqipaddressdatarq=[ipaddress]][numfound][/ > search] > > [/founditems] > > > [/search] > > The inner search shows how many times a given [ipaddress] comes up. > > What I want to display is a summed list of [ipaddress]es, sorted by the > frequency that they occur in the db in descending order. So the results > would look like: > > index ipaddress frequency > ------------------------------------------------ > 1 205.89.222.101 350 > 2 201.22.24.01 227 > 3 111.10.222.15 67 > .... > > Anyone with an idea how I can achieve what I want? > > Will Starck > NovaDerm Skincare Science > http://www.novaderm.com > wjs@novaderm.com > ------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Sorting nested search (Alain Russell 2003)
  2. Re: Sorting nested search (WJ Starck 2003)
  3. Re: Sorting nested search (Alain Russell 2003)
  4. Re: Sorting nested search (WJ Starck 2003)
  5. Re: Sorting nested search (WJ Starck 2003)
  6. Re: Sorting nested search (Donovan home EHG 2003)
  7. Re: Sorting nested search (WJ Starck 2003)
  8. Re: Sorting nested search (Donovan home EHG 2003)
  9. Re: Sorting nested search (Tim Robinson 2003)
  10. Sorting nested search (WJ Starck 2003)
Will, write out a temperary database that contains the amount (frequency) and then do a search with a frequency sort to display....This is a great use for the new [table] tag in 5.0. ;-)DonovanWJ Starck wrote:> This search displays results of a visitors log given an entered date > range: > > [search > db=../dbs/ > sitetrack.db&group1field=accessdate&group2field=accessdate&gegroup1datar > q=[startdate]&legroup2datarq=[enddate]&ipaddresssumm=T&ipaddresssort=1] > > [founditems] > > count=[search > db=../dbs/sitetrack.db&eqipaddressdatarq=[ipaddress]][numfound][/ > search] > > [/founditems] > > > [/search] > > The inner search shows how many times a given [ipaddress] comes up. > > What I want to display is a summed list of [ipaddress]es, sorted by the > frequency that they occur in the db in descending order. So the results > would look like: > > index ipaddress frequency > ------------------------------------------------ > 1 205.89.222.101 350 > 2 201.22.24.01 227 > 3 111.10.222.15 67 > .... > > Anyone with an idea how I can achieve what I want? > > Will Starck > NovaDerm Skincare Science > http://www.novaderm.com > wjs@novaderm.com > ------------------------------------------------------------- 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://webdna.smithmicro.com/ Donovan home EHG

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:

Re[2]: when is failing to [URL]ize values in a comparison ri (1999) [checkboxes] and webcat (2000) Custom WebCat Prefs ... (1997) Using WC for Bulk Emailings (1997) Tracking inbound links for discounts (1997) Re:mac hack (1997) Calendar (1997) Which GUI HTML editors work with WC ? (1997) Showif Error Generated... (2003) [WebDNA] tag [validcard] fails on webdna 7.0. Do I need the commerce edition? (2011) OT: JavaScript question (2001) Test .... (2002) my price won't move (1997) Server crash (1997) [Case] on OS X (2000) crash again (1998) [addlineitem] (1999) Re[2]: Using [Include] Context (1999) Looking up two prices in database? (1997) File Upload (1997)