<%
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'Ben Shaw
'Code connects to excel spreadsheet to retrive dates for upcoming events
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Dim adoCon
Dim rstCC, rstWD, rstOH, rstCR
Const I=1
On Error Resume Next
' Connect to Spreadsheet
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("events.mdb")
If Err.Number = 0 Then
' Create Recordsets
Set rstCC = Server.CreateObject("ADODB.Recordset")
Set rstWD = Server.CreateObject("ADODB.Recordset")
Set rstOH = Server.CreateObject("ADODB.Recordset")
Set rstCR = Server.CreateObject("ADODB.Recordset")
rstCC.LockType = 2
rstWD.LockType = 2
rstOH.LockType = 2
rstCR.LockType = 2
' Get Recordset
rstCC.Open "SELECT ChefClub.* FROM ChefClub;", adoCon
rstWD.Open "SELECT WineDinner.* FROM WineDinner;", adoCon
rstOH.Open "SELECT OpenHouse.* FROM OpenHouse;", adoCon
rstCR.Open "SELECT CollegeRec.* FROM CollegeRec;", adoCon
' Get Next Date from spreadsheet
'While rstCC(1) < Date()
'rstCC.MoveNext
'wend
While rstOH(1) < Date()
rstOH.MoveNext
wend
While rstCR(1) < Date()
rstCR.MoveNext
wend
While rstWD(1) < Date()
rstWD.MoveNext
wend
' Print Results
%>
Chef's Club
<% Response.Write Split(FormatDateTime(rstCC("Date"),1), "day, ")(1) %>
<% Response.Write (rstCC.Fields.Item(I+1).Value ) %>
<% if datediff("d", Date(), cdate(rstCR("Date"))) < 60 then %>
College Recruitment Day
<%= Split(FormatDateTime(rstCR("Date"),1), "day, ")(1) %>
<% end if %>
Wine Tasting Class
<% Response.Write Split(FormatDateTime(rstWD("Date"),1), "day, ")(1) %>
Summer Camp
See Dates
Saturday Chef's Camp
See Dates
10 Year Anniversary Celebration
*By Invitation Only
May 14, 2008
Champagne & Chocolat Scholarship Gala
September 5, 2008