Re: numfound question
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 61752
interpreted = N
texte = Yes, do it like Terry suggested and add more headers to it (maybe) to make the blog online/oflline and then search with that. Might be a better way or let's say it does not complicate things :-))) Nitai Lester wrote: >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/ > > -- 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:
Yes, do it like Terry suggested and add more headers to it (maybe) to make the blog online/oflline and then search with that. Might be a better way or let's say it does not complicate things :-))) Nitai Lester wrote: >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/ > > -- 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:
textarea question (1998)
Card clearance, problems - solutions? (1997)
Freeze (2003)
5.0 Pricing (2003)
WebStar quitting since upgrading to WC4 (2000)
japanese characters (1997)
WebCatalog Hosting (1996)
emailer (1997)
autosensing lanague selection (1997)
Caching [include] files ... (1997)
WebTen and WebCat (1997)
Version number missing (was Mondo amounts of Mail [long]) (1999)
Search a date field specificly the month only... (1999)
Pre-flight public flag (1997)
where to put code (1998)
Stay on Products page (2003)
[WebDNA] Yikes, upgraded to OS Mavericks and now WebDNA not running (2013)
Dates as 20020902 (2002)
Email (1998)
[WebDNA] Escape an ampersand in [middle] (2009)