<%Set RSMONTHNAME = Server.CreateObject("ADODB.Recordset") SQLMONTHNAME = "SELECT * from MonthName" RSMONTHNAME.Open SQLMONTHNAME, Conn, 1, 3%> <%RSMONTHNAME.close set RSMONTHNAME = nothing%><%If RSBODY("Upcoming_Events") = True Then%><%Set RS = Server.CreateObject("ADODB.Recordset") SQL = "SELECT * FROM Events ORDER BY Date" RS.Open SQL, Conn, 1, 3 i = 1 Do while NOT RS.EOF If i <= CInt(RSBODY("Upcoming_Events_Number")) AND datediff("D",now(),RS("Date")) >= 0 Then%>
 Student Information