Web Wiz Support and Community Forums : Select Top 20 Topics Command https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 09 Apr 2026 12:37:50 +0000 Fri, 07 Jul 2006 21:43:32 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=20490 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Select Top 20 Topics Command : Thanks for a quick response that...]]> https://forums.webwiz.net/select-top-20-topics-command_topic20490_post110350.html#110350 Author: lodogg
Subject: 20490
Posted: 07 July 2006 at 9:43pm

Thanks for a quick response that worked great!!]]> Fri, 07 Jul 2006 21:43:32 +0000 https://forums.webwiz.net/select-top-20-topics-command_topic20490_post110350.html#110350 <![CDATA[Select Top 20 Topics Command : Last_entry_date isn&#039;t used...]]> https://forums.webwiz.net/select-top-20-topics-command_topic20490_post110083.html#110083 Author: aks427
Subject: 20490
Posted: 04 July 2006 at 5:04am

Last_entry_date isn't used in v8... now it uses Last_Thread_ID.  I think if your sorted by that instead it would work.]]> Tue, 04 Jul 2006 05:04:31 +0000 https://forums.webwiz.net/select-top-20-topics-command_topic20490_post110083.html#110083 <![CDATA[Select Top 20 Topics Command : So the script is working...]]> https://forums.webwiz.net/select-top-20-topics-command_topic20490_post110066.html#110066 Author: lodogg
Subject: 20490
Posted: 03 July 2006 at 7:19pm

So the script is working where it pulls the newest Top 20 Topics but it does not put the most active topic at the top of the listing?
 

Any help would be much appreciated.

Thanks,

-lo

]]> Mon, 03 Jul 2006 19:19:25 +0000 https://forums.webwiz.net/select-top-20-topics-command_topic20490_post110066.html#110066 <![CDATA[Select Top 20 Topics Command : Please see my piece of...]]> https://forums.webwiz.net/select-top-20-topics-command_topic20490_post109886.html#109886 Author: lodogg
Subject: 20490
Posted: 29 June 2006 at 9:29pm

Please see my piece of code below that I use to pull my top20 posts.  After the upgrade to 8.03 my top 20 posts are not lining upwith the most recent one's listed at the very top?  It is set to list them in a Descendingfashion but I'm by no means an ASP programmer but for the most part it doeslook correct any help would be much appreciated!!

strSQL = "SELECT TOP 20 topic_ID,subject from tblTopic WHERE Forum_ID NOT IN(20) ORDER BY Last_entry_date DESC"

rsLastestPosts.Open strSQL, strCon

Do until rsLastestPosts.eof or rsLastestPosts.bof
strRecentPosts = strRecentPosts + ("<a href=""http://www.lodogg.com/forum/forum_posts.asp?TID=" & rsLastestPosts("topic_ID") & "&PN=1&TPN=1"">" & rsLastestPosts("subject") & "</a><BR>")
rsLastestPosts.movenext
loop

Thanks,
-lo


Edited by lodogg - 29 June 2006 at 9:53pm]]> Thu, 29 Jun 2006 21:29:29 +0000 https://forums.webwiz.net/select-top-20-topics-command_topic20490_post109886.html#109886