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:

Still can't upgrade users.db to 2.1.1 (1998) math on date? (1997) Selected Item in Pop-down (2003) Help! WebCat2 bug (1997) PROBLEM WITH TALK LIST (2000) [TaxableTotal] - not working with AOL and IE (1997) [/application] error? (1997) WebDNA 4.5 rpm?!! (2003) [OT] Ave. Hits Per Day (2006) 2nd WebCatalog2 Feature Request (1996) form data submission gets truncated (1997) cart (1997) WebMerchant Process Orders errors (2000) AAAH: stupid sendmail (2001) [WebDNA] Talklist Archive & Twitter (2009) Country & Ship-to address & other fields ? (1997) UPS charges (2000) 2.1 Stuff (1998) FREE Stuff .. (2003) [SearchString] problem with [search] context (1997)