<% @language="javascript"%> <% dbConn = Server.CreateObject("ADODB.Connection") dbConn.Open("tj") RSboards = dbConn.Execute("Select * FROM BOARD ORDER by NAME") %> the Message Zone - Topics

<% RS = dbConn.Execute("Select * FROM Board WHERE BOARD_ID = " + Request.QueryString("BoardID") + " ORDER by NAME") while(!RS.EOF){ Response.Write("

"+RS.Fields("NAME")+"

") RS.MoveNext() } RS.Close() %>

">">
<% linecntr = 0 RS = dbConn.Execute("Select * FROM TOPIC WHERE BOARD_ID=" + Request.QueryString("BoardID") + " ORDER BY CREATED_DATE DESC") while(!RS.EOF){ linecntr = linecntr + 1 if ( linecntr % 2 == 1 ) { bkcolor = "EEEEEE" } else { bkcolor = "FFFFFF" } topic_board_ID = RS.Fields("BOARD_ID") topic_topic_ID = RS.Fields("TOPIC_ID") Response.Write("") Response.Write("") Response.Write("") Response.Write("") Response.Write("") Response.Write("") RS.MoveNext() } RS.Close() dbConn.Close() %>
  Topic Title Description Started By Msgs
") Response.Write("") Response.Write("") Response.Write(RS.Fields("TITLE")) Response.Write("") Response.Write(RS.Fields("DESCRIPTION")+"") Response.Write(RS.Fields("STARTED_BY")+"") Response.Write("0