<%@LANGUAGE="VBSCRIPT"%> <% Dim rsWorkshop__MMColParam rsWorkshop__MMColParam = "1" If (Request("MM_EmptyValue") <> "") Then rsWorkshop__MMColParam = Request("MM_EmptyValue") End If %> <% Dim rsWorkshop Dim rsWorkshop_numRows Set rsWorkshop = Server.CreateObject("ADODB.Recordset") rsWorkshop.ActiveConnection = MM_CnnEvents_STRING rsWorkshop.Source = "SELECT * FROM tbEvent WHERE eventCategory = " + Replace(rsWorkshop__MMColParam, "'", "''") + " ORDER BY eventID ASC" rsWorkshop.CursorType = 0 rsWorkshop.CursorLocation = 2 rsWorkshop.LockType = 1 rsWorkshop.Open() rsWorkshop_numRows = 0 %> <% Dim rsCalsess__MMColParam rsCalsess__MMColParam = "2" If (Request("MM_EmptyValue") <> "") Then rsCalsess__MMColParam = Request("MM_EmptyValue") End If %> <% Dim rsCalsess Dim rsCalsess_numRows Set rsCalsess = Server.CreateObject("ADODB.Recordset") rsCalsess.ActiveConnection = MM_CnnEvents_STRING rsCalsess.Source = "SELECT * FROM tbEvent WHERE eventCategory = " + Replace(rsCalsess__MMColParam, "'", "''") + " ORDER BY eventID ASC" rsCalsess.CursorType = 0 rsCalsess.CursorLocation = 2 rsCalsess.LockType = 1 rsCalsess.Open() rsCalsess_numRows = 0 %> <% Dim rsExibits__MMColParam rsExibits__MMColParam = "3" If (Request("MM_EmptyValue") <> "") Then rsExibits__MMColParam = Request("MM_EmptyValue") End If %> <% Dim rsExibits Dim rsExibits_numRows Set rsExibits = Server.CreateObject("ADODB.Recordset") rsExibits.ActiveConnection = MM_CnnEvents_STRING rsExibits.Source = "SELECT * FROM tbEvent WHERE eventCategory = " + Replace(rsExibits__MMColParam, "'", "''") + " ORDER BY eventID ASC" rsExibits.CursorType = 0 rsExibits.CursorLocation = 2 rsExibits.LockType = 1 rsExibits.Open() rsExibits_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 rsCalsess_numRows = rsCalsess_numRows + Repeat1__numRows %> <% Dim Repeat3__numRows Dim Repeat3__index Repeat3__numRows = -1 Repeat3__index = 0 rsExibits_numRows = rsExibits_numRows + Repeat3__numRows %> <% Dim Repeat2__numRows Dim Repeat2__index Repeat2__numRows = -1 Repeat2__index = 0 rsWorkshop_numRows = rsWorkshop_numRows + Repeat2__numRows %> <% Dim MM_paramName %> <% ' *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters Dim MM_keepNone Dim MM_keepURL Dim MM_keepForm Dim MM_keepBoth Dim MM_removeList Dim MM_item Dim MM_nextItem ' create the list of parameters which should not be maintained MM_removeList = "&index=" If (MM_paramName <> "") Then MM_removeList = MM_removeList & "&" & MM_paramName & "=" End If MM_keepURL="" MM_keepForm="" MM_keepBoth="" MM_keepNone="" ' add the URL parameters to the MM_keepURL string For Each MM_item In Request.QueryString MM_nextItem = "&" & MM_item & "=" If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then MM_keepURL = MM_keepURL & MM_nextItem & Server.URLencode(Request.QueryString(MM_item)) End If Next ' add the Form variables to the MM_keepForm string For Each MM_item In Request.Form MM_nextItem = "&" & MM_item & "=" If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then MM_keepForm = MM_keepForm & MM_nextItem & Server.URLencode(Request.Form(MM_item)) End If Next ' create the Form + URL string and remove the intial '&' from each of the strings MM_keepBoth = MM_keepURL & MM_keepForm If (MM_keepBoth <> "") Then MM_keepBoth = Right(MM_keepBoth, Len(MM_keepBoth) - 1) End If If (MM_keepURL <> "") Then MM_keepURL = Right(MM_keepURL, Len(MM_keepURL) - 1) End If If (MM_keepForm <> "") Then MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1) End If ' a utility function used for adding additional parameters to these strings Function MM_joinChar(firstItem) If (firstItem <> "") Then MM_joinChar = "&" Else MM_joinChar = "" End If End Function %> Events

ART and SPIRIT Schedule of Events

<% If Not rsWorkshop.EOF Or Not rsWorkshop.BOF Then %>

Workshops

<% While ((Repeat2__numRows <> 0) AND (NOT rsWorkshop.EOF)) %>

<%=(rsWorkshop.Fields.Item("eventTitle").Value)%>

<%=(rsWorkshop.Fields.Item("eventDate").Value)%>
<%=(rsWorkshop.Fields.Item("eventBrif").Value)%>
">more...
********** <% Repeat2__index=Repeat2__index+1 Repeat2__numRows=Repeat2__numRows-1 rsWorkshop.MoveNext() Wend %> <% End If ' end Not rsWorkshop.EOF Or NOT rsWorkshop.BOF %>		 <% If Not rsCalsess.EOF Or Not rsCalsess.BOF Then %>

Ongoing Classes

<% While ((Repeat1__numRows <> 0) AND (NOT rsCalsess.EOF)) %>

<%=(rsCalsess.Fields.Item("eventTitle").Value)%>

<%=(rsCalsess.Fields.Item("eventDate").Value)%>
<%=(rsCalsess.Fields.Item("eventBrif").Value)%> ">
more...
********** <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 rsCalsess.MoveNext() Wend %> <% End If ' end Not rsCalsess.EOF Or NOT rsCalsess.BOF %>		 <% If Not rsExibits.EOF Or Not rsExibits.BOF Then %>

Exhibits

<% While ((Repeat3__numRows <> 0) AND (NOT rsExibits.EOF)) %>

<%=(rsExibits.Fields.Item("eventTitle").Value)%>

<%=(rsExibits.Fields.Item("eventDate").Value)%>
<%=(rsExibits.Fields.Item("eventBrif").Value)%>
 ">more...
********** <% Repeat3__index=Repeat3__index+1 Repeat3__numRows=Repeat3__numRows-1 rsExibits.MoveNext() Wend %> <% End If ' end Not rsExibits.EOF Or NOT rsExibits.BOF %>
Home | About | Events | Gallery | Gift Shop | Contact <% rsWorkshop.Close() Set rsWorkshop = Nothing %> <% rsCalsess.Close() Set rsCalsess = Nothing %> <% rsExibits.Close() Set rsExibits = Nothing %>