ASP Source Code:
<%Option Explicit%>
<!--#include file="ADOsetup.inc"-->
<HTML>
<HEAD>
<%
DIM strSQL,strFields, strItem, strLastItem, strOrderBy
strOrderBy = "fldTopic,fldTaskPriority"
strFields = "fldID,fldTopic,fldTask,fldTaskPriority,fldStatus,fldUser"
strSQL = "Select " & strFields & _
" FROM tblTTDtasks " & _
" WHERE fldTask <> '' " & _
" ORDER BY " & strOrderBy
ADOrs.Open strSQL, ADOcn
SUB DBtable(strField)
strItem = ADOrs.Fields(strField).Value
SELECT CASE strField
CASE "fldTopic":
IF (strLastItem = strItem) THEN
strItem = ""
ELSE
strLastItem = strItem
END IF
CASE "fldTask":
strItem = "<A HREF= " & _
"'DETAIL.ASP?ID=" & _
ADOrs.Fields("fldID").Value & "'>" & _
strItem & "</A>"
END SELECT
Response.Write("<td>")
Response.Write(strItem)
Response.Write("</td>")
END SUB
%>
</HEAD>
<BODY>
<H2><img border="0" Height=40 src="KgLogo.gif">
Things To Do: <font color=Red>All Records<font color=Black></H2><BR>
<table border="1" width="80%">
<tr>
<th>Topic</th>
<th>Task</th>
<th>Priority</th>
<th>Status</th>
<th>User</th>
</tr>
<%
do until ADOrs.EOF
Response.Write("<tr>")
DBtable("fldTopic")
DBtable("fldTask")
DBtable("fldTaskPriority")
DBtable("fldStatus")
DBtable("fldUser")
ADOrs.MoveNext
Response.Write("</tr>")
loop
%>
</table>
<A HREF='EnterNew.asp'>Add New Record</A><BR>
<A HREF='Blackboard.asp'>Kg Systems Blackboard</A>
<!--#include file="ADOclose.inc"-->
</BODY>
</HTML>