<%@LANGUAGE="VBSCRIPT" %> GRPC - Calendar

Here's everything we have going on at GRPC right now. Each section page throughout the site displays the events that have to do with that particular section to help you know which events are for which group. Events that have a image next to them have more details available. Just click the event to bring up a page with more details about the event.

<% sections = request.querystring("sections") if sections <> "" then sectionSQL = " AND FIND_IN_SET(""" & sections & """,section) " if isDate(request.querystring("datestart")) then datestart = request.querystring("datestart") else datestart = "" if isDate(request.querystring("dateend")) then dateend = request.querystring("dateend") else dateend = "" if datestart <> "" then dateSQL = " AND date >= """ & datestart & """ " else dateSQL = " AND date >= """ & localdate & """ " if dateend <> "" then dateSQL = dateSQL & " AND date <= """ & dateend & """ " %>
section:  from:    to:   

<% set rs1 = query("SELECT *,LCASE(TIME_FORMAT(stime,'%l:%i%p')) as starttime,LCASE(TIME_FORMAT(etime,'%l:%i%p')) as endtime FROM events WHERE INSTR(section,""_es"") = 0 " & dateSQL & sectionSQL & " ORDER BY date ASC, stime ASC, section ASC;") %> <% color = "#E5D2AC" %> <% while not rs1.bof and not rs1.eof %> <% currentmonth = month(rs1("date")) %>
');"> " border="0"> <%= monthname(currentmonth) %>
" style="display: inline"> <% do until currentmonth <> month(rs1("date")) %> '" bgcolor="<%= color %>" style="<% if rs1("cancelled") = "1" then %>text-decoration: line-through;<% end if %>cursor: pointer"> <% if color = "#DAC08B" then color = "#E5D2AC" else color = "#DAC08B" %> <% rs1.movenext %> <% if rs1.bof or rs1.eof then exit do %> <% loop %>
<%= rs1("date") %> <%= rs1("starttime") %> <%= rs1("endtime") %> <%= rs1("title") %> <%= rs1("location") %>
<% wend %>