<%@language="javascript" %> <% dbConn = Server.CreateObject("ADODB.Connection") dbConn.Open("tj") catudk = Request.QueryString("cat"); //get category id RScatid = dbConn.Execute("Select * FROM category where catudk='"+catudk+"'") catid = RScatid.Fields("categoryid"); catTitle = RScatid.Fields("category"); sqlstr = "Select * FROM thought where categoryid = "+catid ; TRS = dbConn.Execute(sqlstr); linecntr = 0 %> Thoughts

Thoughts for <%=catTitle%>

 Add A New Thought
Other Categories:
<% while(!TRS.EOF){ linecntr = linecntr + 1 if ( linecntr % 2 == 1 ) { bkclass = "row1" } else{ bkclass = "row2" } %> > <% TRS.MoveNext() ; } TRS.close() RScatid.close(); dbConn.Close(); %>
Thought TitleThinkerDate Submitted
"><%=TRS.Fields("title")%> <%=TRS.Fields("username")%>  <%=TRS.Fields("datecreated")%>