{"id":1196,"date":"2019-07-17T18:18:03","date_gmt":"2019-07-17T18:18:03","guid":{"rendered":"http:\/\/wcsu.wpengine.com\/news-archives\/category\/"},"modified":"2019-07-17T18:18:03","modified_gmt":"2019-07-17T18:18:03","slug":"category","status":"publish","type":"page","link":"https:\/\/www.wcsu.edu\/news-archives\/category\/","title":{"rendered":"University Events: &#8221; &amp; monthName(currentMonth) &amp; &#8221; and &#8221; &amp; monthName(nextMonth) &amp; &#8221; &#8221; &amp; currentYear &amp; &#8220;"},"content":{"rendered":"<p> &#8220;&#8221; Then&#013;<br \/>\n\t\tstrSQL = &#8220;Select to_date(WRBUNEV_START_DATE), to_date(WRBUNEV_END_DATE), WRBUNEV_EVENT_TITLE, WRBUNEV_SHORT_DESC, WRBUNEV_CATEGORY, WRBUNEV_LONG_DESC, WRBUNEV_URL, WRBUNEV_URL_IND, WRBUNEV_EVENT_ID FROM wrbunev WHERE (&#8221; &amp; selectCategory &amp; &#8220;) AND (WRBUNEV_START_DATE &gt;= to_date(&#8216;&#8221; &amp; currentDate &amp; &#8220;&#8216;,&#8217;MM\/DD\/YYYY&#8217;) OR WRBUNEV_END_DATE &gt;= to_date(&#8216;&#8221; &amp; currentDate &amp; &#8220;&#8216;,&#8217;MM\/DD\/YYYY&#8217;)) ORDER BY WRBUNEV_START_DATE,WRBUNEV_ACTIVITY_DATE&#8221;&#013;<br \/>\n&#013;<br \/>\n\t\tstrSQL2 = &#8220;Select to_date(WRBUNEV_START_DATE), to_date(WRBUNEV_END_DATE), WRBUNEV_EVENT_TITLE, WRBUNEV_SHORT_DESC, WRBUNEV_CATEGORY, WRBUNEV_LONG_DESC, WRBUNEV_URL, WRBUNEV_URL_IND, WRBUNEV_EVENT_ID FROM wrbunev WHERE (&#8221; &amp; selectCategory &amp; &#8220;) AND (WRBUNEV_START_DATE &gt;= to_date(&#8216;&#8221; &amp; nextDate &amp; &#8220;&#8216;,&#8217;MM\/DD\/YYYY&#8217;) OR WRBUNEV_END_DATE &gt;= to_date(&#8216;&#8221; &amp; nextDate &amp; &#8220;&#8216;,&#8217;MM\/DD\/YYYY&#8217;)) ORDER BY WRBUNEV_START_DATE,WRBUNEV_ACTIVITY_DATE&#8221;&#013;<br \/>\n\t&#013;<br \/>\n\telseif passport = &#8220;yes&#8221; then&#013;<br \/>\n\t\tstrSQL = &#8220;Select to_date(WRBUNEV_START_DATE), to_date(WRBUNEV_END_DATE), WRBUNEV_EVENT_TITLE, WRBUNEV_SHORT_DESC, WRBUNEV_CATEGORY, WRBUNEV_LONG_DESC, WRBUNEV_URL, WRBUNEV_URL_IND, WRBUNEV_EVENT_ID, WRBUNEV_PASSPORT_IND  FROM wrbunev WHERE WRBUNEV_PASSPORT_IND = &#8216;Y&#8217; AND (WRBUNEV_START_DATE &gt;= to_date(&#8216;&#8221; &amp; currentDate &amp; &#8220;&#8216;,&#8217;MM\/DD\/YYYY&#8217;) OR WRBUNEV_END_DATE &gt;= to_date(&#8216;&#8221; &amp; currentDate &amp; &#8220;&#8216;,&#8217;MM\/DD\/YYYY&#8217;)) ORDER BY WRBUNEV_START_DATE,WRBUNEV_ACTIVITY_DATE&#8221;&#013;<br \/>\n&#013;<br \/>\n\t\tstrSQL2 = &#8220;Select to_date(WRBUNEV_START_DATE), to_date(WRBUNEV_END_DATE), WRBUNEV_EVENT_TITLE, WRBUNEV_SHORT_DESC, WRBUNEV_CATEGORY, WRBUNEV_LONG_DESC, WRBUNEV_URL, WRBUNEV_URL_IND, WRBUNEV_EVENT_ID, WRBUNEV_PASSPORT_IND  FROM wrbunev WHERE WRBUNEV_PASSPORT_IND = &#8216;Y&#8217; AND (WRBUNEV_START_DATE &gt;= to_date(&#8216;&#8221; &amp; nextDate &amp; &#8220;&#8216;,&#8217;MM\/DD\/YYYY&#8217;) OR WRBUNEV_END_DATE &gt;= to_date(&#8216;&#8221; &amp; nextDate &amp; &#8220;&#8216;,&#8217;MM\/DD\/YYYY&#8217;)) ORDER BY WRBUNEV_START_DATE,WRBUNEV_ACTIVITY_DATE&#8221;\t&#013;<br \/>\n\t&#013;<br \/>\n\tEND IF\t&#013;<br \/>\n&#8216; Setup a RecordSet to store the results from our SQL Query.&#013;<br \/>\n\tSet rs = Server.CreateObject(&#8220;ADODB.Recordset&#8221;)&#013;<br \/>\n\trs.Open strSQL, objConn&#013;<br \/>\n\t&#013;<br \/>\n\tSet rs2 = Server.CreateObject(&#8220;ADODB.Recordset&#8221;)&#013;<br \/>\n\trs2.Open strSQL2, objConn&#013;<br \/>\n&#013;<br \/>\n&#8216; check to see if any ADO errors occured&#013;<br \/>\n\tIf Err.number  0 then&#013;<br \/>\n\t  TrapError Err.description&#013;<br \/>\n\tEnd If&#013;<br \/>\n%&gt;&#013;<br \/>\n&#013;<br \/>\n&#013;\n<\/p>\n<p>University Events: &#8221; &amp; monthName(currentMonth) &amp; &#8221; &#8221; &amp; currentYear &amp; &#8221; and &#8221; &amp; monthName(nextMonth) &amp; &#8221; &#8221; &amp; nextYear &amp; &#8220;&#8221;&#013;<br \/>\n\tELSE&#013;<br \/>\n\t\tresponse.write &#8220;<title>University Events: &#8221; &amp; monthName(currentMonth) &amp; &#8221; and &#8221; &amp; monthName(nextMonth) &amp; &#8221; &#8221; &amp; currentYear &amp; &#8220;<\/title>&#8220;&#013;<br \/>\n\tEND IF  &#013;<br \/>\n%&gt;&#013;<br \/>\n<!--[if IE 5]&gt;--><\/p>\n<div id=\"container1\">&#013;<\/p>\n<div id=\"container2\">&#013;<\/p>\n<div id=\"container3\">&#013;<\/p>\n<div id=\"header\"><!-- #include virtual=\"\/include\/new-header.inc\" --><\/div>\n<p>&#013;<\/p>\n<div id=\"leftnav\"><!-- #include virtual=\"\/w\/newsevents\/include\/navbar-left-events.inc\" --><\/div>\n<p>&#013;<\/p>\n<div id=\"middle\">&#013;<\/p>\n<div id=\"breadcrumb\"><!-- #include virtual=\"\/include\/breadcrumb.inc\" --><\/div>\n<p>&#013;<br \/>\n\t\tUniversity Events: &#8221; &amp; monthName(currentMonth) &amp; &#8221; &#8221; &amp; currentYear &amp; &#8221; and &#8221; &amp; monthName(nextMonth) &amp; &#8221; &#8221; &amp; nextYear &amp; &#8220;&#8221;&#013;<br \/>\n\tELSE&#013;<br \/>\n\t\tresponse.write &#8220;<\/p>\n<p class=\"title\">University Events: &#8221; &amp; monthName(currentMonth) &amp; &#8221; and &#8221; &amp; monthName(nextMonth) &amp; &#8221; &#8221; &amp; currentYear &amp; &#8220;<\/p>\n<p>&#8220;&#013;<br \/>\n\tEND IF  &#013;<br \/>\n%&gt;&#013;<\/p>\n<p>\u00a0For more information about events, <a href=\"#contact\">contact &#013;<br \/>\n\tthe Office of University Relations<\/a>.<br \/><i>\u00a0All listings are subject to change. Please call to confirm.<\/i><\/p>\n<p>&#013;<br \/>\n&#8221; &amp; vbCrlf)&#013;<br \/>\nResponse.Write &#8220;<\/p>\n<tr>\n<td colspan=\"2\">\n<h2>&#8221; &amp; ucase(monthName(currentMonth)) &amp; &#8221; EVENTS<\/h2>\n<\/td>\n<\/tr>\n<p>&#8220;&#013;<br \/>\n&#013;<br \/>\nif rs.BOF = true then&#013;<br \/>\nresponse.write &#8220;<\/p>\n<tr>\n<td>There are no &#8221; &amp; category &amp; &#8221; events for this month<\/td>\n<\/tr>\n<p>&#8220;&#013;<br \/>\nend if&#013;<br \/>\n\t\t&#013;<br \/>\n\tdateClass = &#8220;<\/p>\n<tr valign=\"top\">\n<td width=\"85\" class=\"sectiontitle\">&#8220;&#013;<br \/>\n\ttitleClass = &#8220;<\/td>\n<td>&#8220;&#013;<br \/>\n\tcloseSpan = &#8220;<\/td>\n<\/tr>\n<p>&#8220;&#013;<br \/>\n&#013;<br \/>\n&#013;<br \/>\n\tj = 0&#013;<br \/>\n&#8216; Loop through the recordset to retrieve our rows of data.&#013;<br \/>\n   do while rs.EOF = false&#013;<br \/>\n   &#013;<br \/>\n   response.write(WRBUNEV_PASSPORT_IND)&#013;<br \/>\n   &#013;<br \/>\n   \tmoreInfo = &#8221;\u00a0<a href=\"&quot; &amp; rs(6) &amp; &quot;\"><img decoding=\"async\" src=\"\/w\/newsevents\/images\/more_info.gif\" alt=\"More Info\" title=\"More Info\" \/><\/a>&#8220;&#013;<br \/>\n   &#013;<br \/>\n&#8216; get weekday number&#013;<br \/>\n\tnameOfMonth = month(rs(0))&#013;<br \/>\n\tendNameOfMonth = month(rs(1))&#013;<br \/>\n&#013;<br \/>\n&#8216; return abbreviated day&#013;<br \/>\n\tif nameOfMonth = 1 then&#013;<br \/>\n\tnameMonth = &#8220;Jan.&#8221;&#013;<br \/>\n\telseIf nameOfMonth = 2 then&#013;<br \/>\n\tnameMonth = &#8220;Feb.&#8221;&#013;<br \/>\n\telseIf nameOfMonth = 3 then&#013;<br \/>\n\tnameMonth = &#8220;Mar.&#8221;&#013;<br \/>\n\telseIf nameOfMonth = 4 then&#013;<br \/>\n\tnameMonth = &#8220;Apr.&#8221;&#013;<br \/>\n\telseIf nameOfMonth = 5 then&#013;<br \/>\n\tnameMonth = &#8220;May.&#8221;&#013;<br \/>\n\telseIf nameOfMonth = 6 then&#013;<br \/>\n\tnameMonth = &#8220;Jun.&#8221;&#013;<br \/>\n\telseIf nameOfMonth = 7 then&#013;<br \/>\n\tnameMonth = &#8220;Jul.&#8221;&#013;<br \/>\n\telseIf nameOfMonth = 8 then&#013;<br \/>\n\tnameMonth = &#8220;Aug.&#8221;&#013;<br \/>\n\telseIf nameOfMonth = 9 then&#013;<br \/>\n\tnameMonth = &#8220;Sep.&#8221;&#013;<br \/>\n\telseIf nameOfMonth = 10 then&#013;<br \/>\n\tnameMonth = &#8220;Oct.&#8221;&#013;<br \/>\n\telseIf nameOfMonth = 11 then&#013;<br \/>\n\tnameMonth = &#8220;Nov.&#8221;&#013;<br \/>\n\telseIf nameOfMonth = 12 then&#013;<br \/>\n\tnameMonth = &#8220;Dec.&#8221;&#013;<br \/>\n\tend if&#013;<br \/>\n&#013;<br \/>\n&#8216; return abbreviated end day&#013;<br \/>\n\tif endNameOfMonth = 1 then&#013;<br \/>\n\tendNameMonth = &#8220;Jan.&#8221;&#013;<br \/>\n\telseIf endNameOfMonth = 2 then&#013;<br \/>\n\tendNameMonth = &#8220;Feb.&#8221;&#013;<br \/>\n\telseIf endNameOfMonth = 3 then&#013;<br \/>\n\tendNameMonth = &#8220;Mar.&#8221;&#013;<br \/>\n\telseIf endNameOfMonth = 4 then&#013;<br \/>\n\tendNameMonth = &#8220;Apr.&#8221;&#013;<br \/>\n\telseIf endNameOfMonth = 5 then&#013;<br \/>\n\tendNameMonth = &#8220;May&#8221;&#013;<br \/>\n\telseIf endNameOfMonth = 6 then&#013;<br \/>\n\tendNameMonth = &#8220;June.&#8221;&#013;<br \/>\n\telseIf endNameOfMonth = 7 then&#013;<br \/>\n\tendNameMonth = &#8220;Jul.&#8221;&#013;<br \/>\n\telseIf endNameOfMonth = 8 then&#013;<br \/>\n\tendNameMonth = &#8220;Aug.&#8221;&#013;<br \/>\n\telseIf endNameOfMonth = 9 then&#013;<br \/>\n\tendNameMonth = &#8220;Sep.&#8221;&#013;<br \/>\n\telseIf endNameOfMonth = 10 then&#013;<br \/>\n\tendNameMonth = &#8220;Oct.&#8221;&#013;<br \/>\n\telseIf endNameOfMonth = 11 then&#013;<br \/>\n\tendNameMonth = &#8220;Nov.&#8221;&#013;<br \/>\n\telseIf endNameOfMonth = 12 then&#013;<br \/>\n\tendNameMonth = &#8220;Dec.&#8221;&#013;<br \/>\n\tend if&#013;<br \/>\n&#013;<br \/>\n&#8216; check to see if start or end date is greater than current date&#013;<br \/>\n&#8216;\tif isNull(rs(5)) = false then&#013;<br \/>\n\t&#8216; check to see if end date is null&#013;<br \/>\n\tif isNull(rs(1)) = true and month(rs(0)) = currentMonth then&#013;<br \/>\n&#013;<br \/>\n\t\t\tresponse.write dateClass &amp; nameMonth &amp; &#8221; &#8221; &amp; day(rs(0)) &amp; titleClass &amp; &#8221; <strong>&#8221; &amp; rs(2) &amp; &#8220;:\u00a0<\/strong>  &#8221; &amp; rs(5)&#013;<br \/>\n\t\t\t&#013;<br \/>\n\t\t\t&#8216; check to see if event has more info link&#013;<br \/>\n\t\t\tIF isNull(rs(6)) = false Then&#013;<br \/>\n\t\t\t\t\tresponse.write(moreInfo)&#013;<br \/>\n\t\t\tEND IF&#013;<br \/>\n\t\t\t&#013;<br \/>\n\t\t\tresponse.write closeSpan&#013;<br \/>\n\t\t\tj = j + 1&#013;<br \/>\n\t\t\t&#013;<br \/>\n\t&#8216; check to see if there in an end date&#013;<br \/>\n\telseif month(rs(0)) = currentMonth then&#013;<br \/>\n\t\t\t&#8216;check to see if the end is equal to the current month&#013;<br \/>\n\t\t\tif month(rs(1)) = currentMonth then&#013;<br \/>\n\t\t\t\t&#013;<br \/>\n\t\t\t\t\tresponse.write dateClass &amp; nameMonth &amp; &#8221; &#8221; &amp; day(rs(0)) &amp; &#8221; &#8211; &#8221; &amp; day(rs(1)) &amp; titleClass &amp; &#8221; <strong>&#8221; &amp; rs(2) &amp; &#8220;:\u00a0<\/strong>  &#8221; &amp; rs(5)&#013;<br \/>\n\t\t\t\t\t&#8216; check to see if event has more info link&#013;<br \/>\n\t\t\t\t\tIF isNull(rs(6)) = false Then&#013;<br \/>\n\t\t\t\t\t\t\tresponse.write(moreInfo)&#013;<br \/>\n\t\t\t\t\tEND IF&#013;<br \/>\n\t\t\t\t\t&#013;<br \/>\n\t\t\t\t\tresponse.write closeSpan&#013;<br \/>\n\t\t\t\t\tj = j + 1&#013;<br \/>\n\t\t\telse&#013;<br \/>\n\t\t\t\t\tresponse.write dateClass &amp; nameMonth &amp; &#8221; &#8221; &amp; day(rs(0)) &amp; &#8221; &#8211; &#8221; &amp; left(monthName(month(rs(1))),3) &amp; &#8220;. &#8221; &amp; day(rs(1)) &amp; titleClass &amp; &#8221; <strong>&#8221; &amp; rs(2) &amp; &#8220;:\u00a0<\/strong>  &#8221; &amp; rs(5)&#013;<br \/>\n\t\t\t\t\t&#8216; check to see if event has more info link&#013;<br \/>\n\t\t\t\t\tIF isNull(rs(6)) = false Then&#013;<br \/>\n\t\t\t\t\t\t\tresponse.write(moreInfo)&#013;<br \/>\n\t\t\t\t\tEND IF&#013;<br \/>\n\t\t\t\t\tresponse.write closeSpan&#013;<br \/>\n\t\t\t\t\tj = j + 1&#013;<br \/>\n\t\t\t&#013;<br \/>\n\t\tend if&#013;<br \/>\n\tend if&#013;<br \/>\n&#8216;end if&#013;<br \/>\n&#013;<br \/>\nrs.moveNext&#013;<br \/>\nloop&#013;<br \/>\n&#013;<br \/>\nif j = 0 then&#013;<br \/>\nresponse.write &#8220;<\/p>\n<tr>\n<td>There are no &#8221; &amp; category &amp; &#8221; events for this month<\/td>\n<\/tr>\n<p>&#8220;&#013;<br \/>\nend if&#013;<br \/>\n&#013;<br \/>\n&#8216; SECOND MONTH LIST&#013;<br \/>\n&#013;<br \/>\nResponse.Write &#8220;<\/p>\n<tr>\n<td colspan=\"2\">\n<h2>&#8221; &amp; ucase(monthName(nextMonth)) &amp; &#8221; EVENTS<\/h2>\n<\/td>\n<\/tr>\n<p>&#8220;&#013;<br \/>\n&#013;<br \/>\nif rs2.BOF = true then&#013;<br \/>\nresponse.write &#8220;<\/p>\n<tr>\n<td>There are no &#8221; &amp; category &amp; &#8221; events for this month<\/td>\n<\/tr>\n<p>&#8220;&#013;<br \/>\nend if&#013;<br \/>\n&#013;<br \/>\nj = 0&#013;<br \/>\n&#013;<br \/>\n   do while rs2.EOF = false&#013;<br \/>\n   &#013;<br \/>\n   \tmoreInfo = &#8221;\u00a0<a href=\"&quot; &amp; rs2(6) &amp; &quot;\"><img decoding=\"async\" src=\"\/w\/newsevents\/images\/more_info.gif\" alt=\"More Info\" title=\"More Info\" \/><\/a>&#8220;&#013;<br \/>\n   &#013;<br \/>\n&#8216; get weekday number&#013;<br \/>\n\tnameOfMonth = month(rs2(0))&#013;<br \/>\n\tendNameOfMonth = month(rs2(1))&#013;<br \/>\n&#013;<br \/>\n&#8216; return abbreviated day&#013;<br \/>\n\tif nameOfMonth = 1 then&#013;<br \/>\n\tnameMonth = &#8220;Jan&#8221;&#013;<br \/>\n\telseIf nameOfMonth = 2 then&#013;<br \/>\n\tnameMonth = &#8220;Feb.&#8221;&#013;<br \/>\n\telseIf nameOfMonth = 3 then&#013;<br \/>\n\tnameMonth = &#8220;Mar.&#8221;&#013;<br \/>\n\telseIf nameOfMonth = 4 then&#013;<br \/>\n\tnameMonth = &#8220;Apr.&#8221;&#013;<br \/>\n\telseIf nameOfMonth = 5 then&#013;<br \/>\n\tnameMonth = &#8220;May.&#8221;&#013;<br \/>\n\telseIf nameOfMonth = 6 then&#013;<br \/>\n\tnameMonth = &#8220;Jun.&#8221;&#013;<br \/>\n\telseIf nameOfMonth = 7 then&#013;<br \/>\n\tnameMonth = &#8220;Jul.&#8221;&#013;<br \/>\n\telseIf nameOfMonth = 8 then&#013;<br \/>\n\tnameMonth = &#8220;Aug.&#8221;&#013;<br \/>\n\telseIf nameOfMonth = 9 then&#013;<br \/>\n\tnameMonth = &#8220;Sep.&#8221;&#013;<br \/>\n\telseIf nameOfMonth = 10 then&#013;<br \/>\n\tnameMonth = &#8220;Oct.&#8221;&#013;<br \/>\n\telseIf nameOfMonth = 11 then&#013;<br \/>\n\tnameMonth = &#8220;Nov.&#8221;&#013;<br \/>\n\telseIf nameOfMonth = 12 then&#013;<br \/>\n\tnameMonth = &#8220;Dec.&#8221;&#013;<br \/>\n\tend if&#013;<br \/>\n&#013;<br \/>\n&#8216; return abbreviated end day&#013;<br \/>\n\tif endNameOfMonth = 1 then&#013;<br \/>\n\tendNameMonth = &#8220;Jan.&#8221;&#013;<br \/>\n\telseIf endNameOfMonth = 2 then&#013;<br \/>\n\tendNameMonth = &#8220;Feb.&#8221;&#013;<br \/>\n\telseIf endNameOfMonth = 3 then&#013;<br \/>\n\tendNameMonth = &#8220;Mar.&#8221;&#013;<br \/>\n\telseIf endNameOfMonth = 4 then&#013;<br \/>\n\tendNameMonth = &#8220;Apr.&#8221;&#013;<br \/>\n\telseIf endNameOfMonth = 5 then&#013;<br \/>\n\tendNameMonth = &#8220;May&#8221;&#013;<br \/>\n\telseIf endNameOfMonth = 6 then&#013;<br \/>\n\tendNameMonth = &#8220;June.&#8221;&#013;<br \/>\n\telseIf endNameOfMonth = 7 then&#013;<br \/>\n\tendNameMonth = &#8220;Jul.&#8221;&#013;<br \/>\n\telseIf endNameOfMonth = 8 then&#013;<br \/>\n\tendNameMonth = &#8220;Aug.&#8221;&#013;<br \/>\n\telseIf endNameOfMonth = 9 then&#013;<br \/>\n\tendNameMonth = &#8220;Sep.&#8221;&#013;<br \/>\n\telseIf endNameOfMonth = 10 then&#013;<br \/>\n\tendNameMonth = &#8220;Oct.&#8221;&#013;<br \/>\n\telseIf endNameOfMonth = 11 then&#013;<br \/>\n\tendNameMonth = &#8220;Nov.&#8221;&#013;<br \/>\n\telseIf endNameOfMonth = 12 then&#013;<br \/>\n\tendNameMonth = &#8220;Dec.&#8221;&#013;<br \/>\n\tend if&#013;<br \/>\n&#013;<br \/>\n&#8216; check to see if start or end date is greater than current date&#013;<br \/>\n\t&#8216;if isNull(rs2(5)) = false then&#013;<br \/>\n\t&#8216; check to see if end date is null&#013;<br \/>\n\tif isNull(rs2(1)) = true and month(rs2(0)) = nextMonth then&#013;<br \/>\n&#013;<br \/>\n\t\t\tresponse.write dateClass &amp; nameMonth &amp; &#8221; &#8221; &amp; day(rs2(0)) &amp; titleClass &amp; &#8221; <strong>&#8221; &amp; rs2(2) &amp; &#8220;:\u00a0<\/strong>  &#8221; &amp; rs2(5)&#013;<br \/>\n\t\t\t&#013;<br \/>\n\t\t\t&#8216; check to see if event has more info link&#013;<br \/>\n\t\t\tIF isNull(rs2(6)) = false Then&#013;<br \/>\n\t\t\t\t\tresponse.write(moreInfo)&#013;<br \/>\n\t\t\tEND IF&#013;<br \/>\n\t\t\tj = j + 1&#013;<br \/>\n\t\t\tresponse.write closeSpan&#013;<br \/>\n\t\t\t&#013;<br \/>\n\t&#8216; check to see if there in an end date&#013;<br \/>\n\telseif month(rs2(0)) = nextMonth then&#013;<br \/>\n\t\t\t&#8216;check to see if the end is equal to the current month&#013;<br \/>\n\t\t\tif month(rs2(1)) = currentMonth then&#013;<br \/>\n\t\t\t\t&#013;<br \/>\n\t\t\t\t\tresponse.write dateClass &amp; nameMonth &amp; &#8221; &#8221; &amp; day(rs2(0)) &amp; &#8221; &#8211; &#8221; &amp; day(rs2(1)) &amp; titleClass &amp; &#8221; <strong>&#8221; &amp; rs2(2) &amp; &#8220;:\u00a0<\/strong>  &#8221; &amp; rs2(5)&#013;<br \/>\n\t\t\t\t\t&#8216; check to see if event has more info link&#013;<br \/>\n\t\t\t\t\tIF isNull(rs2(6)) = false Then&#013;<br \/>\n\t\t\t\t\t\t\tresponse.write(moreInfo)&#013;<br \/>\n\t\t\t\t\tEND IF&#013;<br \/>\n\t\t\t\t\tj = j + 1&#013;<br \/>\n\t\t\t\t\tresponse.write closeSpan&#013;<br \/>\n\t\t\telse&#013;<br \/>\n\t\t\t\t\tresponse.write dateClass &amp; nameMonth &amp; &#8221; &#8221; &amp; day(rs2(0)) &amp; &#8221; &#8211; &#8221; &amp; left(monthName(month(rs2(1))),3) &amp; &#8220;. &#8221; &amp; day(rs2(1)) &amp; titleClass &amp; &#8221; <strong>&#8221; &amp; rs2(2) &amp; &#8220;:\u00a0<\/strong>  &#8221; &amp; rs2(5)&#013;<br \/>\n\t\t\t\t\t&#8216; check to see if event has more info link&#013;<br \/>\n\t\t\t\t\tIF isNull(rs2(6)) = false Then&#013;<br \/>\n\t\t\t\t\t\t\tresponse.write(moreInfo)&#013;<br \/>\n\t\t\t\t\tEND IF&#013;<br \/>\n\t\t\t\t\tj = j + 1&#013;<br \/>\n\t\t\t\t\tresponse.write closeSpan&#013;<br \/>\n\t\t\t&#013;<br \/>\n\t\tend if&#013;<br \/>\n\tend if&#013;<br \/>\n&#8216;\tend if&#013;<br \/>\n&#013;<br \/>\nrs2.moveNext&#013;<br \/>\nloop&#013;<br \/>\nif j = 0 then&#013;<br \/>\nresponse.write &#8220;<\/p>\n<tr>\n<td>There are no &#8221; &amp; category &amp; &#8221; events for this month<\/td>\n<\/tr>\n<p>&#8220;&#013;<br \/>\nend if&#013;<br \/>\n&#8216; Close connections and recordsets&#013;<br \/>\n   set rs = nothing&#013;<br \/>\n   set rs2 = nothing&#013;<br \/>\n   objConn.close&#013;<br \/>\n   set objConn = nothing&#013;<br \/>\n   &#013;<br \/>\n   response.write(&#8220;&#8221;)&#013;<br \/>\n%&gt;&#013;<br \/>\n&#013;<\/p>\n<p><i>All listings are subject to change. Please call to confirm.<\/i><\/p>\n<p>&#013;<\/p>\n<p><strong>VISITOR PARKING ADVISORY: <\/strong> Western Connecticut State University offers several convenient, centrally located parking spaces for visitors to the university\u2019s Midtown and Westside campuses in Danbury. Midtown visitor parking is in the lot next to Old Main and in designated spaces next to University Hall. Parking in the university\u2019s White Street garage is restricted to commuter students, faculty and staff from 6 a.m. to 6 p.m. Monday through Thursday; visitors are welcome to park in the garage all other times. Westside visitor parking is on University Boulevard. Visitors who cannot be accommodated in these parking areas are asked to call the University Police Department to make other arrangements.<\/p>\n<p>&#013;<\/p>\n<p>Up-to-date university parking rules and regulations, color-coded campus maps that show parking areas and shuttle bus stops, and shuttle bus schedules are available at <a href=\"https:\/\/www.wcsu.edu\/parking\">www.wcsu.edu\/parking<\/a>. Call the University Police Department at (203) 837-9300 for more information about the parking rules and regulations. <\/p>\n<p>&#013;<\/p>\n<hr \/>\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"5\">\n<tr>\n<td colspan=\"2\"><i><a name=\"contact\" \/>For more information, &#013;<br \/>\n                  please contact:<\/i><\/td>\n<p>&#013;<br \/>\n               <\/tr>\n<tr>\n<td colspan=\"2\">Sherri Hill, Associate Director, University Relations<\/td>\n<p>&#013;<br \/>\n               <\/tr>\n<tr>\n<td width=\"159\">Phone: (203) 837-8486<\/td>\n<p>&#013;<\/p>\n<td width=\"169\">Fax: (203) 837-8530<\/td>\n<p>&#013;<br \/>\n               <\/tr>\n<tr>\n<td colspan=\"2\">E-Mail: <a href=\"mailto:pr@wcsu.edu\">&#013;<br \/>\n                  pr@wcsu.edu<\/a><\/td>\n<p>&#013;<br \/>\n               <\/tr>\n<\/table>\n<div id=\"facebookShare\"><!-- #include virtual=\"\/include\/facebookshare.inc\" --><\/div>\n<p>&#013;\n        <\/p><\/div>\n<p>&#013;<\/p>\n<div class=\"clear\" \/>&#013;\n    <\/div>\n<p>&#013;\n<\/p><\/div>\n<p>&#013;<\/p>\n<footer id=\"footer\"><!-- #include virtual=\"\/include\/footer.inc\" --><\/footer>\n<div id=\"tabsContainer\">&#013;<br \/>\n\t<!-- #include virtual=\"\/include\/toolbar.inc\" -->&#013;\n<\/div>\n<p>&#013;<\/p>\n<div class=\"panelContainer\">&#013;<br \/>\n\t<!-- #include virtual=\"\/include\/share.inc\" -->&#013;\n<\/div>\n<p>&#013;<br \/>\n<!-- #include virtual=\"\/include\/bottomscripts.inc\" -->&#013;<br \/>\n&#013;<br \/>\n&#013;\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;&#8221; Then&#013; strSQL = &#8220;Select to_date(WRBUNEV_START_DATE), to_date(WRBUNEV_END_DATE), WRBUNEV_EVENT_TITLE, WRBUNEV_SHORT_DESC, WRBUNEV_CATEGORY, WRBUNEV_LONG_DESC, WRBUNEV_URL, WRBUNEV_URL_IND, WRBUNEV_EVENT_ID FROM wrbunev WHERE (&#8221; &amp; selectCategory &amp; &#8220;) AND (WRBUNEV_START_DATE &gt;= to_date(&#8216;&#8221; &amp; currentDate &amp; &#8220;&#8216;,&#8217;MM\/DD\/YYYY&#8217;) OR WRBUNEV_END_DATE &gt;= to_date(&#8216;&#8221; &amp; currentDate &amp; &#8220;&#8216;,&#8217;MM\/DD\/YYYY&#8217;)) ORDER BY &hellip;<\/p>\n","protected":false},"author":4,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1196","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.wcsu.edu\/news-archives\/wp-json\/wp\/v2\/pages\/1196","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wcsu.edu\/news-archives\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.wcsu.edu\/news-archives\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.wcsu.edu\/news-archives\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wcsu.edu\/news-archives\/wp-json\/wp\/v2\/comments?post=1196"}],"version-history":[{"count":0,"href":"https:\/\/www.wcsu.edu\/news-archives\/wp-json\/wp\/v2\/pages\/1196\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.wcsu.edu\/news-archives\/wp-json\/wp\/v2\/media?parent=1196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}