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 StarckNovaDerm Skincare Sciencehttp://www.novaderm.comwjs@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 StarckNovaDerm Skincare Sciencehttp://www.novaderm.comwjs@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:
Creating PDF (2004)
Forumulas.db & Variables (2002)
WebDNA equivalent for $REQUEST_URI (2004)
Format of Required fields error message (1997)
Resume Catalog ? (1997)
my SOS last week... (1996)
[showif],[refferer],[include] in errormessages.db (2002)
Where is f2? (1997)
Setting up shop (1997)
Mondo amounts of Mail [long] (1999)
ooops...WebCatalog [FoundItems] Problem - LONG - (1997)
Searchable WebCat (etc.) Docs ? (1997)
verify online (1997)
WebMerchant bomb (1998)
WebCat2b12 - nesting [tags] (1997)
authenticate and password (1998)
WebCatalog can't find database (1997)
WebDNA 6 (2004)
JavaScript (1998)
Sending E-mail (1997)