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:

    
  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)
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)