Sorting nested search

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 49023
interpreted = N
texte = 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)
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/ WJ Starck

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:

Country & Ship-to address & other fields ? (1997) Deleting Orders (1997) Trigger Problems (2001) Return records from another (1997) [WebDNA] webdna's svn repositories (2009) [include file=filename.inc&strip=t] (2002) Uh...can someone help me out with the b10? (1997) Nesting [ListFiles] (1998) Problems getting parameters passed into email. (1997) Shownext never shows next...still (1997) Sendmail not sending (2004) Test (2003) [SHOWIF AND/OR] (1997) Snake Bites (1997) A few questions. . . (1997) using showpage and showcart commands (1996) A link and two command (1998) form data submission gets truncated (1997) 4.5 to 5.0 question (2003) Using Plug-In while running 1.6.1 (1997)