Print Page | Close Window

Forum description in forum_topics.asp

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums Modifications
Forum Description: Mod's and Add-on's for Web Wiz Forums.
URL: https://forums.webwiz.net/forum_posts.asp?TID=21847
Printed Date: 29 March 2026 at 10:54pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Forum description in forum_topics.asp
Posted By: suedechaser
Subject: Forum description in forum_topics.asp
Date Posted: 06 November 2006 at 11:15am

Hi all,

Is it possible to view the forum description on the forum_topics.asp under the forum name as well as on default.asp?

thanks in advance

regards

suede



Replies:
Posted By: Hades
Date Posted: 07 November 2006 at 7:38am

The description is stored in the DB. Check on default.asp where it is and copy it into forum_topics.asp. It's a simple text line.



-------------
Hades[hLcYb¿]

-What're quantum mechanics?
-I don't know. People who repair quantums, I suppose.

--Rincewind, Discworld


Posted By: suedechaser
Date Posted: 07 November 2006 at 1:59pm
I found the following:

Response.Write("<br />" & strForumDiscription)

but alas, did not work.

Could you give a hint as to which line you are referring to please Hades?

regards

suede


Posted By: suedechaser
Date Posted: 10 November 2006 at 5:50am
Hi,

Can anyone else pass on a little hint please?

regards

suede


Posted By: jsaren
Date Posted: 10 November 2006 at 7:52am

This is my forum code what how to show Forum description

=============================
Dim strForumDescription      'Holds the forum description
=============================
'Read the various forums from the database
'Initalise the strSQL variable with an SQL statement to query the database
strSQL = "" & _
"SELECT " & strDbTable & "Forum.Forum_ID, " & strDbTable & "Forum.Forum_name, " & strDbTable & "Forum.Forum_description, " & strDbTable & "Forum.No_of_topics, " & strDbTable & "Forum.No_of_posts, " & strDbTable & "Author.Username, " & strDbTable & "Forum.Last_post_author_ID, " & strDbTable & "Forum.Last_post_date, " & strDbTable & "Forum.Password, " & strDbTable & "Forum.Locked, " & strDbTable & "Forum.Hide, " & strDbTable & "Permissions.View_Forum " & _
"FROM " & strDbTable & "Forum" & strDBNoLock & ", " & strDbTable & "Permissions" & strDBNoLock & ", " & strDbTable & "Author" & strDBNoLock & " " & _
"WHERE " & strDbTable & "Forum.Forum_ID = " & strDbTable & "Permissions.Forum_ID " & _
 "AND " & strDbTable & "Forum.Last_post_author_ID = " & strDbTable & "Author.Author_ID " & _
 "AND " & strDbTable & "Forum.Sub_ID = " & intForumID & " " & _
 "AND (" & strDbTable & "Permissions.Author_ID = " & lngLoggedInUserID & " OR " & strDbTable & "Permissions.Group_ID=" & intGroupID & ") " & _
"ORDER BY " & strDbTable & "Forum.Forum_Order, " & strDbTable & "Permissions.Forum_ID;"
'Set error trapping
On Error Resume Next
=================================
<table class="basicTable" cellspacing="0" cellpadding="3" align="center">
 <tr>
  <td align="left" class="heading"  rowspan="2"><%
'Display the forum name and description
Response.Write(strForumName)
'If the forum is locked show a locked pad lock icon
If blnForumLocked = True Then Response.Write ("  <span class=""smText"">(<img src=""" & strImagePath & "forum_locked_icon.gif"" align=""baseline"" alt=""" & strTxtForumLocked & """> " & strTxtForumLocked & ")</span>")
%></td>
<td class="text" align="right">
<%
Response.Write(""& strForumDescription &"")
%></td>
 


Posted By: suedechaser
Date Posted: 10 November 2006 at 10:14pm
Hi jsaren,

Thank you. I couldn't get it to work until I added the following line:

'Read in forum details from the database
     intCatID = CInt(rsCommon("Cat_ID"))
     strCatName = rsCommon("Cat_name")
     strForumName = rsCommon("Forum_name")
     strMasterForumName = rsCommon("Main_forum")
     intMasterForumID = CLng(rsCommon("Sub_ID"))
     blnForumLocked = CBool(rsCommon("Locked"))
     intShowTopicsWithin = CInt(rsCommon("Show_topics"))
     strForumDescription = rsCommon("Forum_Description")

regards

suede


Posted By: jsaren
Date Posted: 11 November 2006 at 2:56am
hehe,u r right!



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net