Web Wiz Support and Community Forums : Script for the front *.asp page https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 13:10:05 +0000 Fri, 16 Jan 2004 13:44:32 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=8953 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Script for the front *.asp page : Thanks that got me in the right...]]> https://forums.webwiz.net/script-for-the-front-asp-page_topic8953_post47367.html#47367 Author: lodogg
Subject: 8953
Posted: 16 January 2004 at 1:44pm

Thanks that got me in the right direction...  I need some more help but it's working now.

 

Thanks,

Lo

]]> Fri, 16 Jan 2004 13:44:32 +0000 https://forums.webwiz.net/script-for-the-front-asp-page_topic8953_post47367.html#47367 <![CDATA[Script for the front *.asp page : Simple: Dim strRecentPostsstrSQL...]]> https://forums.webwiz.net/script-for-the-front-asp-page_topic8953_post47250.html#47250 Author: Gullanian
Subject: 8953
Posted: 15 January 2004 at 9:21pm

Simple:


Dim strRecentPosts
strSQL = "SELECT TOP 10 topic_ID,subject from tblTopic ORDER BY Last_entry_date DESC"
rsCommon.open strSQL, adoCon
Do until rscommon.eof or rsCommon.bof
strRecentPosts = strRecentPosts + ("<a href=""http://www.yoursite/forum/forum_posts.asp?TID=" & RsCommon("topic_ID") & "&PN=1&TPN=1"">" & rsCommon("subject") & "</a><BR>")
rsCommon.movenext
loop
rsCommon.close

Then wherever you want the recent posts box simply put:


<%=strRecentPosts%>



Edited by Gullanian]]> Thu, 15 Jan 2004 21:21:58 +0000 https://forums.webwiz.net/script-for-the-front-asp-page_topic8953_post47250.html#47250 <![CDATA[Script for the front *.asp page : I know I asked this before:( But...]]> https://forums.webwiz.net/script-for-the-front-asp-page_topic8953_post47249.html#47249 Author: lodogg
Subject: 8953
Posted: 15 January 2004 at 9:17pm

I know I asked this before:(  But I searched and searched and I would like a script that will call up the top 5 or 10 most recent posts to my main *.asp web page.  I still  can't find it.  Can some one please post a link or just post the scipt.  I have the mod to post the 5 most recent posts to the main FORUM page but I would like to pull these most recent post on my front WEB page... 

Thanks in Advance

Lo

 

PS

You can see what I'm trying to accomplish from my link below.

Thanks.................

You can see what I'm trying

]]> Thu, 15 Jan 2004 21:17:36 +0000 https://forums.webwiz.net/script-for-the-front-asp-page_topic8953_post47249.html#47249