<%Option Explicit%>
New Page 1
<%
Dim objCon, objRecordset, strSQL, arrData, intcount, goalSQL, goalData, pimSQL, pimData, teamSQL, teamData
set objCon=Server.CreateObject("adodb.connection")
set objRecordset=Server.CreateObject("adodb.recordset")
objCon.connectionstring="Provider=Microsoft.jet.oledb.4.0;Data Source= " & server.mappath("\llhl\db\llhl.mdb") & ";" & "Persist Security Info=False"
strSQL="SELECT * FROM tblPlayers WHERE team='Wat' ORDER BY tblPlayers.points DESC, tblPlayers.goals DESC, tblPlayers.gp ASC"
objCon.open
objRecordset.open strSQL, objCon
arrData=objRecordset.getRows
objRecordset.close
goalSQL="SELECT * FROM tblGoalies WHERE team='Wat' ORDER BY tblGoalies.avg"
objRecordset.open goalSQL, objCon
goalData=objRecordset.getRows
objRecordset.close
teamSQL="SELECT * FROM tblTeams WHERE id=1"
objRecordset.open teamSQL, objCon
teamData=objRecordset.getRows
objRecordset.close
%>
WELCOME TO THE 2011/12 LLHL SEASON
Provincial dates are now being
set. Check the Provincials page for updates.
SCHEDULE CHANGES:
Wednesday, February 1st Davidson @ Nokomis has
been rescheduled for Tuesday, February 7th.
Wednesday, January 18th Davidson @ LeRoy has
been rescheduled for Wednesday, February 8th.
Wednesday,
December 28th Nokomis @ LeRoy has been rescheduled for Thursday, February 9th.
League
Use
`
<%
set objCon = nothing
set objRecordset = nothing
%>