Re: numfound question
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 61748
interpreted = N
texte = How about creating a field in the bloggers called numposted, and increment that value each time they post. It's just an extra [replace] context when a posting happens, and makes for easy code later with no more nested searches just to get a numfound. Or you could update this field whenever there's action on the blog.db with a blogger.db search -> blog.db search -> numfound -> replace routine instead, if it's too much of a hassle to add code to keep the increment technique accurate due to editing or other issues like deleted posts, back button abuse, etc. Terry > 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 > > > > > -- -- Terry Wilson | terry@terryfic.com | http://terryfic.com creator of: http://WhosComing.com - a simplified, affordable online reservation system http://WhosBringingWhat.com - online potluck signup sheet -------------------------------------------------------------------------- ------------------------------------------------------------- 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:
How about creating a field in the bloggers called numposted, and increment that value each time they post. It's just an extra [replace] context when a posting happens, and makes for easy code later with no more nested searches just to get a numfound. Or you could update this field whenever there's action on the blog.db with a blogger.db search -> blog.db search -> numfound -> replace routine instead, if it's too much of a hassle to add code to keep the increment technique accurate due to editing or other issues like deleted posts, back button abuse, etc. Terry > 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 > > > > > -- -- Terry Wilson | terry@terryfic.com | http://terryfic.com creator of: http://WhosComing.com - a simplified, affordable online reservation system http://WhosBringingWhat.com - online potluck signup sheet -------------------------------------------------------------------------- ------------------------------------------------------------- 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/
Terry Wilson
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:
Need Advice for Setting up a Database (1999)
Navigator 4.01 (1997)
[date] formatting bug inside [orderfile]? (1998)
WebCatalog for LinuxPPC/SusePPC? (2000)
Another question (1997)
Not sending email !!! (2002)
surf express & webcat (1998)
off topic - dna snipets (1997)
RE: Purchased cart being overwritten - still !?? (1997)
Error: the 'showcart' command requires that you specify a db (1997)
Cannot calculate prices (1997)
SSL and reg web* (1997)
Nested tags count question (1997)
quick GREP question (2001)
WebCat2 several catalogs? (1997)
calculating tax rates, mail order solutions and version 2 (1997)
ShowCart (2001)
ShowIf & HideIf Question? (1998)
Site Search Concepts (2003)
Hosting WebDNA (2006)