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:
Kanji in http requests (1998)
[WebDNA] v 7 append (2012)
More Applescript (1997)
Sorting problem (2002)
Generating unique SKU from [cart] - Still Stumped... (1997)
problems with WebCat-Plugin (1997)
[showif]?[/showif] (2000)
Problem with version 4 browsers (1998)
wierd [cart] action! (1997)
Duplicate Carts (2000)
WebCat2b13MacPlugIn - More limits on [include] (1997)
[WebDNA] Help me install (WebDNA 7 fastcgi install on Lion 10.7.3) (2012)
Caching [include] files ... (1997)
Cart -> Date and Time (2004)
WebCatalog vs. Cold Fusion (1998)
Server, Java and WebCatalog (2001)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Templates on Unix & CGI on Mac? (1997)
Tracking (2004)
How to verify email address (1997)