Re: numfound question

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 61747
interpreted = N
texte = that should be doable with a embedded search: [search db=blogger.db&gebloggeriddata=0] [founditems] [search db=blogs.db&eqbloggeriddatarq=[field]&bloggeridsumm=T][numfound][/search] [/founditems] [/search] In the first search you want to find all bloggers and in the second you find all the blogs from this bloggers id and summarize by the id. Sort of like this should get you going. Nitai PS: Next time post some code, to make it easier to help you. Lester wrote: >I saw this sorta answered in talklist archives but the >posts were from 2000. Thinking there might be a better >way perhaps before I start... > >First off, I'm using 4.5 on IIS. > >I have a small blog type site. >One db has all the bloggers >One db has all the blogs > >I want to show how many blog entries each of the >bloggers have posted, and then sort them with the one >having the most posts first etc... > >example: >blogger8 (7 posts) >blogger4 (5 posts) >blogger3 (4 posts) >etc etc > >The only way to do this seems to be to create a temp >database, (or a maybe daily one since it will be >accessed many times on the front page.) and then do a >search and sort etc on that. > >summ=T or numfound or other combos of code snippets >with search and/or an embedded search within weren't >producing what I want. > >Is my assumption correct or has someone come up with >an easy way to do this? > >Or maybe 6 makes this type of solution easier??? >(sigh) > > >Thanks > > > > > >__________________________________________________ >Do You Yahoo!? >Tired of spam? Yahoo! Mail has the best spam protection around >http://mail.yahoo.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/ > > -- Redakto - Content Management that simply works Content Management & eBusiness Systems ComputerOil® AG Dammstrasse 7 5400 Baden / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.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:

    
  1. Re: numfound question: SORTnumfound=ain't gonna happen ( Terry Wilson 2005)
  2. Re: numfound question ( Gary Krockover 2005)
  3. Re: numfound question ( Lester 2005)
  4. Re: numfound question ( "Nitai @ ComputerOil" 2005)
  5. Re: numfound question ( Lester 2005)
  6. Re: numfound question ( "Nitai @ ComputerOil" 2005)
  7. Re: numfound question ( Terry Wilson 2005)
  8. Re: numfound question ( Lester 2005)
  9. Re: numfound question ( Terry Wilson 2005)
  10. Re: numfound question ( Terry Wilson 2005)
  11. Re: numfound question ( "Nitai @ ComputerOil" 2005)
  12. numfound question ( Lester 2005)
that should be doable with a embedded search: [search db=blogger.db&gebloggeriddata=0] [founditems] [search db=blogs.db&eqbloggeriddatarq=[field]&bloggeridsumm=T][numfound][/search] [/founditems] [/search] In the first search you want to find all bloggers and in the second you find all the blogs from this bloggers id and summarize by the id. Sort of like this should get you going. Nitai PS: Next time post some code, to make it easier to help you. Lester wrote: >I saw this sorta answered in talklist archives but the >posts were from 2000. Thinking there might be a better >way perhaps before I start... > >First off, I'm using 4.5 on IIS. > >I have a small blog type site. >One db has all the bloggers >One db has all the blogs > >I want to show how many blog entries each of the >bloggers have posted, and then sort them with the one >having the most posts first etc... > >example: >blogger8 (7 posts) >blogger4 (5 posts) >blogger3 (4 posts) >etc etc > >The only way to do this seems to be to create a temp >database, (or a maybe daily one since it will be >accessed many times on the front page.) and then do a >search and sort etc on that. > >summ=T or numfound or other combos of code snippets >with search and/or an embedded search within weren't >producing what I want. > >Is my assumption correct or has someone come up with >an easy way to do this? > >Or maybe 6 makes this type of solution easier??? >(sigh) > > >Thanks > > > > > >__________________________________________________ >Do You Yahoo!? >Tired of spam? Yahoo! Mail has the best spam protection around >http://mail.yahoo.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/ > > -- Redakto - Content Management that simply works Content Management & eBusiness Systems ComputerOil® AG Dammstrasse 7 5400 Baden / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.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/ "Nitai @ ComputerOil"

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:

[ShowNext] (1997) Multiple Items (2004) WebCatalog [FoundItems] Problem - LONG - (1997) [searchString] (1997) Showing unopened cart (1997) Wireless WebDNA available today! (2000) How can I Add several Items into the cart at once? (1997) Snake Bites (1997) Cut off from the list and can't get an answer to the confused re:QTY price updating question (1998) errors 550, and 108 (1998) How does the Globals folder work? (2000) Attn: Bug in GeneralStore example b15 (1997) Problems with [Search] param - Mac Plugin b15 (1997) Using files in an Email broadcast (1999) If Empty ? (1997) searchable list archive (1997) [WriteFile] problems (1997) Table sorting by selected category then others (2004) WebCat2 - many [carts] on one template page? (1997) WebCat editing, SiteGuard & SiteEdit (1997)