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