The application of ASP technology in the forum. (iv) (build the full program of the forum, vomiting blood recommended!!!! ）

Article Display module
As I said before, a specific article is divided between the Kanban and the subject. Therefore, it is possible to get a list of articles under a specific topic by displaying the articles through both the Kanban list and the main list.
Now let's take a look at the display page of the Board list:
　　
< html>
< head>
< title> Kanban List </title>
< meta http-equiv= "Content-type" content= "text/html; charset=gb2312 ">
<%
' Open the connection, display the Kanban list
Set conn = Server.CreateObject ("ADODB. Connection ")
Conn. Open "Driver={microsoft Access driver (*.mdb)};d bq=" & Server.MapPath ("Bbssystem.mdb")
sql = "SELECT * FROM Kanban list"
Set Rs=conn.execute (SQL)
%>
A simple SQL query that passes all Kanban information back to the recordset Rs. The following task is to display the record and remember the content, and set up a link to display the Kanban theme on the corresponding Kanban name.
　　
< body bgcolor= "#FFFFFF" >
< h2 align= "center" > Kanban List < table width= "60%" border= "0" cellspacing= "0" cellpadding= "0" align= "center" >
< tr bgcolor= "#FFFFCC" >
< TD height= "Width=" "25%" > Kanban name </td>
< TD height= "Width=" "21%" > Board main </td>
< TD height= "Width=" "23%" > Topics </td>
< TD height= "Width=" "31%" > Board main landing </td>
</tr>
　　
Here's a section that shows the title of each column in the table, where I don't use a uniform function to display the RS record, because it gives more control over the appearance and style of the table, but it's more flexible to use, although it's a bit cumbersome.
　　
<%
Todo
BOARDID=RS ("id")
Boardname=rs ("name")
Boardmanager=rs ("board Master")
　　
Response.Write "< tr>< td>< a href=qboard.asp?boardid=" & Boardid & "&boardname=" & Boardname & ">" & Boardname & "</a></td>"