Re: [numfound] within summ=t ???
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 33023
interpreted = N
texte = Some days agoo I ask a question like the one you are asking now. Peter Ostry answered this way and works great for me:---------------------No way with summ alone, because this parameter is *supposed* to deliver unique values. You might search for existing categories with summ, and get the number of each category in a second (nested) search. For the example I assume your database field is named db_cat. Don't miss allcase=t in the nested search, because this makes it much faster: [search db=my.db&neDB_CATdatarq=[blank]&DB_CATsort=1&DB_CATsumm=t] [founditems] [text]v_cat=[db_cat][/text] [search db=my.db&eqDB_CATdatarq=[v_cat]&allcase=t] [v_cat] ([numfound)
[/search] [/founditems] [/search] Note: If you do not have all available categories in the database but want those categories listed like cat4 (0) you can't use the nested search. Then you search for each known category seperately. Peter ----------------------Hope this help. -Rodolfo de la Garza El 6/10/00 8:49 AM, Joseph D'Andrea JoeDan@West21.com escribió:> I've asked this question twice before and never received any answer, > so I'm going to try one more time... > > Will there be a variable that contains the number of items found for > each [founditems] when doing a search with summ=t ? > > Given this database: > joe 11215 > mary 11215 > tom 11236 > > And this WebDNA > [search ... ZIPsumm=t] > [founditems] > [zip] [summnumfound] [!] Not a real WebCat Context [/!] > [/founditems][/search] > > Would yield: > > 11215 2 > 11236 1 > > The alternative is to do an embeded search within the [founditems] > and that does work, but in really large databases with lots of unique > values in a certain field, this can be very time consuming. > > Thanks, > ___Joe___ > > _________________________________________________ > Joseph D'Andrea JoeDan@West21.com > WEST21.com Internet services for the 21st Century > http://www.west21.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://search.smithmicro.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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Some days agoo I ask a question like the one you are asking now. Peter Ostry answered this way and works great for me:---------------------No way with summ alone, because this parameter is *supposed* to deliver unique values. You might search for existing categories with summ, and get the number of each category in a second (nested) search. For the example I assume your database field is named db_cat. Don't miss allcase=t in the nested search, because this makes it much faster: [search db=my.db&neDB_CATdatarq=[blank]&DB_CATsort=1&DB_CATsumm=t] [founditems] [text]v_cat=[db_cat][/text] [search db=my.db&eqDB_CATdatarq=[v_cat]&allcase=t] [v_cat] ([numfound)
[/search] [/founditems] [/search] Note: If you do not have all available categories in the database but want those categories listed like cat4 (0) you can't use the nested search. Then you search for each known category seperately. Peter ----------------------Hope this help. -Rodolfo de la Garza El 6/10/00 8:49 AM, Joseph D'Andrea JoeDan@West21.com escribió:> I've asked this question twice before and never received any answer, > so I'm going to try one more time... > > Will there be a variable that contains the number of items found for > each [founditems] when doing a search with summ=t ? > > Given this database: > joe 11215 > mary 11215 > tom 11236 > > And this WebDNA > [search ... ZIPsumm=t] > [founditems] > [zip] [summnumfound] [!] Not a real WebCat Context [/!] > [/founditems][/search] > > Would yield: > > 11215 2 > 11236 1 > > The alternative is to do an embeded search within the [founditems] > and that does work, but in really large databases with lots of unique > values in a certain field, this can be very time consuming. > > Thanks, > ___Joe___ > > _________________________________________________ > Joseph D'Andrea JoeDan@West21.com > WEST21.com Internet services for the 21st Century > http://www.west21.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://search.smithmicro.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://search.smithmicro.com/
Rodolfo de la Garza
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:
How far do [showif]s go? (1997)
[WebDNA] mydatabase.db-oRiGiNaL- (2016)
[OT] XML data to tab delimited database (2003)
Requiring that certain fields be completed (1997)
Associative lookup style? + bit more (1997)
Summing fields (1997)
[WebDNA] Announcing the new features for the next WebDNA version (2015)
Running _every_ page through WebCat-error.html (1997)
more trouble with [showif] in [search] = busted [shownext] (2000)
LetterRip and WebCat (1998)
Please post more "exceptions to the rules" ... (2005)
[WebDNA] The Single-Vendor Commercial Open Source Business Model (2012)
typhoon... (1997)
Web Catalog vs. ICAT (1997)
Country & Ship-to address & other fields ? (1997)
[ShowNext] (1997)
Online Docs for the Beta... (2000)
RequiredFields template (1997)
Add message to Order (1997)
ShipTotal question (1998)