<% Dim objConn Dim strConn Set objConn = Server.CreateObject("ADODB.Connection") ' Response.Write Server.MapPath("/fpdb/WCST2010TEAM.MDB") ' Without a password - need to use CAIN to identify passord and use Access to convert the mdb file and unset the DP PW ObjConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/fpdb/WCST2010TEAM.mdb") ' Identified the PW via CAIN. Can just upload the mdb file from c:\TMIIData\yyyy ' ObjConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/fpdb/WCST2010TEAM.mdb") & "; Password=Hy-TEK17" %> WCST Stingrays Meet Results

 

2010 WCST Stingrays Swimmer Statistics

Please select a swimmer to view results...

Select Swimmers Name: <% dim oRScl Dim strSQL strSQL = "SELECT DISTINCT ATHLETE.ATHLETE, ATHLETE.LAST, ATHLETE.FIRST, ATHLETE.INITIAL " & _ "FROM ATHLETE INNER JOIN RESULT ON ATHLETE.ATHLETE = RESULT.ATHLETE " & _ "ORDER BY LAST, FIRST, INITIAL;" set oRScl=server.createobject("ADODB.recordset") oRScl.Open strSQL, objConn oRScl.movefirst %>

  

If you think a time is missing, please contact the WCST Statistician Mark Boucher at boucher@astound.net.  It is possible that a time was not recorded correctly or that they were disqualified.  In either case, they end up with 0 for a time.  Zero's are omitted from these statistics.

Medal Awards

Swimmer Stats Archive