StarDust you are awesome! Thanks.. Obviously I am a network guy not a programmer : \
I do have one more issue I am pulling the top 8 topics to my front page and when I add the code above it seems to break the page? The line that kills everything is the (include).
<!--#include file="forum/common.asp" -->
Here is a snippet of code I’m using to pull my topics.
<%
Dim rsLastestPosts
Dim strPosts
Dim adoCon
Dim strCon
Dim strSQL
Dim strRecentPosts
'Create a connection odject
Set adoCon = Server.CreateObject("ADODB.Connection")
'Database connection info and driver
strCon = "Provider=;Data Source=;Database=forum;User ID=;Password=;"
'Set an active connection to the Connection object
adoCon.Open strCon
Set rsLastestPosts = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT TOP 8 topic_ID,subject from tblTopic WHERE Forum_ID NOT IN(9,10,14,19,31) ORDER BY Last_Thread_ID 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
rsLastestPosts.close
%>
<%= strRecentPosts %>