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 thendo 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 thendo 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)