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:

Email template names (1997) WebCat2b12--[searchstring] bug (1997) Getting the protocol (2004) LOOP and IF statements (1997) New Guestbook Source (1997) WebCatalog memory error. (1998) Multiple catalog databases and showcart (1997) LetterRip and WebCat (1998) using showpage and showcart commands (1996) [TaxableTotal] - not working with AOL and IE (1997) Redirect frame targets (1998) WebCat and AppleShare 6.0 (1998) [Listfiles] vs Netfinder (1997) Multiple SSL Keys (1998) Setting up WebCatalog with Retail Pro data (1996) [URGENT] Different Results From Math Tag Depending On OS (2006) Can WC remember people? (1998) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Problems reading files created by WC (1997) TeaRoom Order fields email account remain empty even though thewy are filled. (1997)