Re: Num Found by category
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 32654
interpreted = N
texte = Peter, Thanks for your help, this works great. -RodolfoEl 6/2/00 5:58 PM, Peter Ostry po@ostry.com escribió:> on 03.06.2000 4:15, Rodolfo de la Garza at listas@edifika.com wrote: > >> I have a search context with categorysumm in it. >> I want to display the categories with the number of items found in each >> category as: >> >> cat1 (5) >> cat2 (33) >> cat3 (3) > > 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 > > > ------------------------------------------------------------- > 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:
Peter, Thanks for your help, this works great. -RodolfoEl 6/2/00 5:58 PM, Peter Ostry po@ostry.com escribió:> on 03.06.2000 4:15, Rodolfo de la Garza at listas@edifika.com wrote: > >> I have a search context with categorysumm in it. >> I want to display the categories with the number of items found in each >> category as: >> >> cat1 (5) >> cat2 (33) >> cat3 (3) > > 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 > > > ------------------------------------------------------------- > 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:
WebCatalog NT beta 18 problem (1997)
Undeliverable Mail (1997)
webcatalog [date] bug...not (1999)
WebCat Beta NT 18 (1997)
RE: PIXO support (1997)
emailer (1997)
Sendmail & Time Issue (2001)
[username][password] not showing up! HELP! (1999)
denied access (1997)
Feature Request (2003)
Am I going senile? (Price recalc based on quantity) (1997)
More on the email templates (1997)
sendmail spaces (1997)
Prevent multiple appends with Reload Button (1997)
Firesite cache vs webcat cache (1997)
WebCatalog NT beta 18 problem (1997)
How To question on setting up downloads (1997)
Corruption in images (2004)
Hosting (1998)
My solution... (1996)