Re: numfound question
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 61750
interpreted = N
texte = Nitai, I was just starting to think about the code when I first posted, and had nothing to show at that moment. Here's what I have now that "sorta" works, but not really I first seach the blogs.db database to find ones that are "visible" and actual "blogs" and not the comments: "BlogBy" is the unique ID that is assigned to each blogger.... [Search db=^/eb/blogs.db&eqVISIBLEdatarq=YES&eqCommentTodatarq=NewBlog&BlogBysort=1&BlogBysumm=T] [Founditems] I then search the bloggers.db to only show the approved and active bloggers: "BlogBy" and "BloggerID" are always the same across the 2 db's [Search db=^/eb/bloggers.db&eqSTATUSdatarq=OK&eqBloggerIDdatarq=[BlogBy]] [Founditems] [DisplayName]
[/Founditems] [/Search] [/Founditems] [/Search] This combo gives me a list of all bloggers with blog posts, a good start, but I'm not able to get a show of how many entries each made and sort that blogger list from most to least. I'm thinking a new field as Terry suggested might be a better way to go, although it is actually possible for a blogger to make one of their posts not visible, so only visible blogs should be counted, and I really was hoping to make this as uncomplicated as possible LOL. --- "Nitai @ ComputerOil"
wrote: > 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/ > __________________________________ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ ------------------------------------------------------------- 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:
Nitai, I was just starting to think about the code when I first posted, and had nothing to show at that moment. Here's what I have now that "sorta" works, but not really I first seach the blogs.db database to find ones that are "visible" and actual "blogs" and not the comments: "BlogBy" is the unique ID that is assigned to each blogger.... [Search db=^/eb/blogs.db&eqVISIBLEdatarq=YES&eqCommentTodatarq=NewBlog&BlogBysort=1&BlogBysumm=T] [founditems] I then search the bloggers.db to only show the approved and active bloggers: "BlogBy" and "BloggerID" are always the same across the 2 db's [Search db=^/eb/bloggers.db&eqSTATUSdatarq=OK&eqBloggerIDdatarq=[BlogBy]] [founditems] [DisplayName]
[/Founditems] [/Search] [/Founditems] [/Search] This combo gives me a list of all bloggers with blog posts, a good start, but I'm not able to get a show of how many entries each made and sort that blogger list from most to least. I'm thinking a new field as Terry suggested might be a better way to go, although it is actually possible for a blogger to make one of their posts not visible, so only visible blogs should be counted, and I really was hoping to make this as uncomplicated as possible LOL. --- "Nitai @ ComputerOil" wrote: > 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/ > __________________________________ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ ------------------------------------------------------------- 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/
Lester
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:
Summary search -- speed (1997)
'does not contain' operator needed ... (1997)
About the + sign (2002)
[WriteFile] problems (1997)
WebCatalog NT beta 18 problem (1997)
Pithy questions on webcommerce & siteedit (1997)
File not found error message (1998)
WebCat2 Append problem (B14Macacgi) (1997)
Problems with shopping cart (1997)
HELP WITH DATES (1997)
Need help from WebDNA user using WebStar Plugin (2005)
Banner ads example (1997)
emailer (1997)
What are these prefs for? (1999)
WC2b12: Yes, Formulas.db is for real (1997)
WebCat Hosting - Pricing Question (2002)
Referrer from multiple entry points (1998)
Interfacing WebMerchant to www.fedex.com (1997)
WC2.0 Memory Requirements (1997)
[WebDNA] To be or not to be friendly (URLs) (2011)