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:
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:Add (1998)
For those of you not on the WebCatalog Beta... (1997)
Re[2]: 2nd WebCatalog2 Feature Request (1996)
OS Limitations (1998)
and vs or vs not (1998)
Cart# (1997)
no global [username] or [password] displayed ... (1997)
Showing Results Alphabetically in Columns (top to bottom) (2002)
Re:Remote stockroom ? (1998)
Emailer compatibility..... (1998)
[WebDNA] Mac Question (2018)
RAM crash (1998)
Math (1997)
page redirect in webDNA (1997)
[getchars] questions (1997)
using showpage and showcart commands (1996)
Requiring that certain fields be completed (1997)
Getting total number of items ordered (1997)
Webten + Webcat running smooth (1998)
encryption in browser? (1998)