Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*Need\s+a\s+quick\s+way\s+to\s+list\s+off\s+my\s+archive\s+descriptions\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*Need\s+a\s+quick\s+way\s+to\s+list\s+off\s+my\s+archive\s+descriptions\s*$/: 4 ]

Total 4 documents matching your query.

1. Need a quick way to list off my archive descriptions (score: 1): Author: "Brazner, Bob" <Bob.Brazner AT JCI DOT COM>; Date: Wed, 19 Sep 2001 16:36:34 -0500; What SQL can I code to get a quick list of the archives I may have taken for a given node. I'm interested in getting the unique "descriptions". If I code select description from archives blah blah bl; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2001-09/msg00546.html (10,913 bytes)
2. Re: Need a quick way to list off my archive descriptions (score: 1): Author: Andrew Raibeck <storman AT US.IBM DOT COM>; Date: Wed, 19 Sep 2001 19:51:48 -0700; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2001-09/msg00547.html (10,531 bytes)
3. Re: Need a quick way to list off my archive descriptions (score: 1): Author: Bill Colwell <bcolwell AT DRAPER DOT COM>; Date: Thu, 20 Sep 2001 10:29:27 -0400; Bob - try this macro. You are on the right track but you need the distinct function. I just ran it for a node with 20,000 archive files and it took 15 seconds wallclock. /* */ /* macro file to select; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2001-09/msg00560.html (12,040 bytes)
4. Re: Need a quick way to list off my archive descriptions (score: 1): Author: Bill Colwell <bcolwell AT DRAPER DOT COM>; Date: Thu, 20 Sep 2001 10:40:05 -0400; Bob - Here is another macro you might find useful. /* */ /* */ set sqldatetimeformat i set sqldisplaymode w set sqlmathmode r commit select count(*), type, left(description,96) as description - from; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2001-09/msg00563.html (11,895 bytes)

Current List: 1 - 4
Page: [1]