%@LANGUAGE="VBSCRIPT"%>
<%
if session("coachid")<>"" then
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_dbConn_STRING
Recordset1.Source = "SELECT * FROM coach WHERE coachid ="& session("coachid")
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
else
response.redirect "Coaches.asp"
mymessage = "You must login before entering the Coaches area. Click Here to login."
end if
%>
<%
Dim Recordset2a
Dim Recordset2a_numRows
Set Recordset2a = Server.CreateObject("ADODB.Recordset")
Recordset2a.ActiveConnection = MM_dbConn_STRING
Recordset2a.Source = "SELECT * FROM teams WHERE CoachId=" & session("coachid")
Recordset2a.CursorType = 0
Recordset2a.CursorLocation = 2
Recordset2a.LockType = 1
Recordset2a.Open()
Recordset2a_numRows = 0
%>
<%
Dim rsRosters
Dim rsRosters_numRows
Set rsRosters = Server.CreateObject("ADODB.Recordset")
rsRosters.ActiveConnection = MM_dbConn_STRING
rsRosters.Source = "SELECT * FROM qryroster WHERE CoachId =" & session("coachid") & " ORDER BY RaceDate DESC"
rsRosters.CursorType = 0
rsRosters.CursorLocation = 2
rsRosters.LockType = 1
rsRosters.Open()
rsRosters_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index
Repeat1__numRows = -1
Repeat1__index = 0
rsRosters_numRows = rsRosters_numRows + Repeat1__numRows
%>
<%
Dim Repeat2__numRows
Dim Repeat2__index
Repeat2__numRows = -1
Repeat2__index = 0
Recordset2a_numRows = Recordset2a_numRows + Repeat2__numRows
%>
You are logged in as
<% = Recordset1.fields.item("firstname") %>
<%=Recordset1.fields.item("lastname")%> If this is not correct, please click here to log out. |
|||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||