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

<% sqlstr = "Select * FROM TOPIC WHERE TOPIC_ID="+Request.QueryString("topicID") var topicName = dbConn.Execute(sqlstr); while(!topicName.EOF){ Response.Write("

Topic: "+topicName.Fields("TITLE")+"

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

">
<% linecntr = 0 RS = dbConn.Execute("Select * FROM MESSAGE WHERE TOPIC_ID=" + Request.QueryString("topicID") + " ORDER BY CREATED_DATE DESC") while(!RS.EOF){ linecntr = linecntr + 1 if ( linecntr % 2 == 1 ) { bkcolor = "EEEEEE" } else { bkcolor = "FFFFFF" } Response.Write("") Response.Write("") Response.Write("") Response.Write("") Response.Write("") RS.MoveNext() } RS.Close() dbConn.Close() %>
Body Posted By Posted On
") Response.Write(RS.Fields("BODY")) Response.Write("") Response.Write(RS.Fields("UID")+"") Response.Write(RS.Fields("CREATED_DATE")+"