<%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 2008/2009 LLHL season!
The Strasbourg Maroons have joined the LLHL
this season. As a result, there will be a 24 game schedule (double home and home
with each team) this season and the interlocking schedule with the Wheatland
Hockey League has been eliminated.
SCHEDULE CORRECTION: The
printed schedules that are out have an error. The game on Wednesday, January
14th should be Drake @ Nokomis (incorrectly posted as Drake @ Lanigan).
League
Use
`
<%
set objCon = nothing
set objRecordset = nothing
%>