---

<% 'Dimension variables Dim adoCon 'Holds the Database Connection Object Dim rsGuestbook 'Holds the recordset for the records in the database Dim strSQL 'Holds the SQL query for the database Dim recordsonpage Dim allrecords Dim selectsport Dim season Dim gender selectsport="Wrestling" season="Winter Sports" gender="Athletics - Men" recordsonpage=1 allrecords=0 'Create an ADO connection odject Set adoCon = Server.CreateObject("ADODB.Connection") 'Set an active connection to the Connection object using a DSN-less connection adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/sports/havensports/dbase/sportsdata.mdb") 'Set an active connection to the Connection object using DSN connection 'adoCon.Open "DSN=guestbook" 'Create an ADO recordset object Set rsGuestbook = Server.CreateObject("ADODB.Recordset") 'Initialise the strSQL variable with an SQL statement to query the database strSQL = "SELECT official.* FROM official WHERE official.sport='" & selectsport & "'" & "ORDER BY releaseyear DESC, releasemonth DESC, releaseday DESC;" 'Open the recordset with the SQL query rsGuestbook.Open strSQL, adoCon 'Loop through the recordset Do Until allrecords=recordsonpage 'Do While not rsGuestbook.EOF allrecords=allrecords+1 %> <% If rsGuestbook("photomatch")>"0" Then %> "> <% End IF %>

<%= rsGuestbook("releasemonth") & "/" & rsGuestbook("releaseday") & "/" & rsGuestbook("releaseyear")%> <%= rsGuestbook("title")%> <% Dim vCnt , vDone, vCntr, vPos, vTmp vCnt = 1 vDone = 0 vCntr = 1 vPos = 1 vTmp = "" vTmp = rsGuestbook("body") While vCntr <=1 AND vDone = 0 vPos = Instr(vCnt, vTmp, CHR(13) & CHR(10),1) If vPos > 1 then vCnt = vPos + 2 vCntr = vCntr + 1 Else vDone = 1 End If Wend If vPos <> 0 then vTmp = Left(vTmp, vPos-1) End If response.write vTmp %> "> <% rsGuestbook.MoveNext Loop 'Reset server objects rsGuestbook.Close Set rsGuestbook = Nothing Set adoCon = Nothing %>

10/03/2007 Groft and LHU Women's Wrestling Team in Full Swing

LOCK HAVEN, Pa. - Lock Haven University’s women’s wrestling program got off to good start as Rachael Groft earned a national ranking in the Collegiate Women’s Poll on the USA Wrestling website TheMat.com. for January.  Groft’s  #5 ranking was enough to get the LHU program a #9 team ranking nationally as well. Groft returned to LHU in the fall in order to compete for the newly established program, and her impact was felt immediately.