Re: Sorting nested search
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 49028
interpreted = N
texte = Thanks, Donovan.I need a temp db with 2 fields, ipaddress and frequency.How do I create this?I thought of using [writefile], but the docs say the name should not be a database that WebDNA currently has open. So do I have to have a [closedatabase] tag in my template after the results are displayed?TIA,WillOn Sunday, March 30, 2003, at 04:12 PM, Donovan home EHG wrote:> 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. ;-) > > Donovan > > > > WJ Starck wrote: > >> This search displays results of a visitors log given an entered date >> range: >> >> [search >> db=../dbs/ >> sitetrack.db&group1field=accessdate&group2field=accessdate&gegroup1dat >> ar >> 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/ > > --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:
Thanks, Donovan.I need a temp db with 2 fields, ipaddress and frequency.How do I create this?I thought of using [writefile], but the docs say the name should not be a database that WebDNA currently has open. So do I have to have a [closedatabase] tag in my template after the results are displayed?TIA,WillOn Sunday, March 30, 2003, at 04:12 PM, Donovan home EHG wrote:> 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. ;-) > > Donovan > > > > WJ Starck wrote: > >> This search displays results of a visitors log given an entered date >> range: >> >> [search >> db=../dbs/ >> sitetrack.db&group1field=accessdate&group2field=accessdate&gegroup1dat >> ar >> 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/ > > --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:
access denied problem (1997)
Next (1997)
Re:2nd WebCatalog2 Feature Request (1996)
[SHOWIF AND/OR] (1997)
mime types (2003)
Is [thisurl] http or https? (1998)
No luck with taxes (1997)
Max Record length (1997)
Re:Emailer and encryption (1997)
I'm new be kind (1997)
problems with 2 tags (1997)
WebCat2 - Getting to the browser's username/password data (1997)
sort problems....bug or brain fart? (1997)
New WebCatalog site! (1997)
Emailer prefs in two places ... (1997)
[ShowNext] feature in 2.0 (1997)
database size? (1997)
Narrowing NT Crashing error (2000)
Multi Colonns (1998)
WebCat2: multiple currency support (1997)