Re: Num Found by category
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 32652
interpreted = N
texte = 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 deliverunique values.You might search for existing categories with summ, and get the number ofeach category in a second (nested) search. For the example I assume yourdatabase field is named db_cat. Don't miss allcase=t in the nestedsearch, 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 wantthose 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/
Associated Messages, from the most recent to the oldest:
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 deliverunique values.You might search for existing categories with summ, and get the number ofeach category in a second (nested) search. For the example I assume yourdatabase field is named db_cat. Don't miss allcase=t in the nestedsearch, 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 wantthose 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/
Peter Ostry
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:
SetHeader not Working (2006)
OT : javascript form filling (2000)
Improved ISAPI extension (2004)
Trigger Validation Text Broken (2003)
Credit card types (1997)
Silly date question (2006)
WebSite and *NO* Authentication Dialog Box!!? (1998)
Searching multiple Databases (1997)
Help needed! (1998)
EditPlus 2 WebDNA cliptext (2002)
RE: [isfolder] and [filename] (1997)
Shell traceroute (2001)
WebCat and image maps (1997)
Summing fields (1997)
IP Shows Server (2003)
Questions (1998)
Non-Cart Files in Shopping Cart Folder (1997)
Force a number (1998)
Hello??? (1997)
Decrypting a user password (2000)