First off: It works right on the display_topic_threads.asp but not on display_forum_tropics.asp .
Ok:
Dim strUsernameColor
Dim strUsernameBackColor
---------------------------------------------
'Initalise the strSQL variable with an SQL statement to query the database to get the Author and subject from the database for the topic
If strDatabaseType = "SQLServer" Then
strSQL = "EXECUTE wwfSpLastAndFirstThreadAuthor @lngTopicID = " & lngTopicID
Else
strSQL = "SELECT tblThread.Thread_ID, tblThread.Author_ID, tblThread.Message_date, tblAuthor.Username, tblAuthor.Username_back_color, tblAuthor.Username_color "
strSQL = strSQL & "FROM tblAuthor INNER JOIN tblThread ON tblAuthor.Author_ID = tblThread.Author_ID "
strSQL = strSQL & "WHERE tblThread.Topic_ID = " & lngTopicID & " "
strSQL = strSQL & "ORDER BY tblThread.Message_date ASC;"
End If
-----------------------------------------
strUsernameColor = rsTopic("Username_color")
strUsernameBackColor = rsTopic("Username_back_color")
--------------------------------------------
<a href="JavaScript:openWin('pop_up_profile.asp?profile=<% = lngTopicStartUserID %>&ForumID=<% = intForumID %>','profile','toolbar=0,location=0,status=0,menubar=0,scrollbars=0,resizable=1,width=440,height=370')">
<span style="color: <% = strUsernameColor %>; font-weight: bold; font-style: normal; background-color: <% = strUsernameBackColor %>; text-decoration: none;">
<b><font size=2>
<% = strTopicStartUsername %>
</b></span>
</a>
Edited by worldwide1504
Topic Options
Post Options
Thanks(0)
