<% if rstCourse.RecordCount > 0 then %>
<% do while (not rstCourse.EOF)%>
| "><%=rstCourse("course")%>
<%strTSQL="select DISTINCT batchfrom, batchto from alumni where course = '" & rstCourse("course") & "'"
rstBatch.CursorLocation = 3
rstBatch.Open strTSQL,dbcn,3,3
if rstBatch.RecordCount > 0 then
do while (not rstBatch.EOF)%> |
<%=rstBatch("batchfrom")%>-<%=rstBatch("batchto")%> |
<%
strSQL="select * from alumni where batchfrom = '" & rstBatch("batchfrom") & "' and course = '"& rstCourse("course") & "' order by st_name"
rstInfo.CursorLocation = 3
rstInfo.Open strSQL,dbcn,3,3
if rstInfo.RecordCount > 0 then
do while (not rstInfo.EOF)
Response.Write "| " & rstInfo("st_name") & " | "
rstInfo.MoveNext
loop
rstInfo.Close
End if
rstBatch.MoveNext
loop
rstBatch.Close
End if %>
| top
|
<%rstCourse.MoveNext
loop
rstCourse.Close
end if%>
|