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:

dynamic giffing. (2000) Pithy questions on webcommerce & siteedit (1997) [WebDNA] XML Help (2009) Reversed words (1997) [include ...] behavior (1997) Nested tags count question (1997) SetHeader (1999) [WebDNA] how to make webroot the start of path (2017) [CART] (1997) Generating Report Totals (1997) URL encoding (1998) SiteCheck & WebCat ? (1997) Mac Vs WindowsNT (1997) Server Freeze (1998) Sort Floating Point Number (2008) Show if file exists (2004) SiteGaurd file Cache vs webcatalog cache (1997) WebCatalog can't find database (1997) Discounts: Buy One, Get One =?ISO-8859-1?Q?99=A2?= (2004) Quitting WebMerchant ? (1997)