Creative Cornices | Upcoming Shows

<% @LANGUAGE = "JAVASCRIPT" %> <% var rsUpcomingShows__MMColParam = "cc"; if(String(Request("MM_EmptyValue")) != "undefined") { rsUpcomingShows__MMColParam = String(Request("MM_EmptyValue")); } %> <% var rsUpcomingShows = Server.CreateObject("ADODB.Recordset"); rsUpcomingShows.ActiveConnection = MM_bdccdata_STRING; rsUpcomingShows.Source = "SELECT Date, Title, Place, Location FROM UpcomingShows WHERE UpcomShowID = '"+ rsUpcomingShows__MMColParam.replace(/'/g, "''") + "' ORDER BY Date DESC"; rsUpcomingShows.CursorType = 0; rsUpcomingShows.CursorLocation = 2; rsUpcomingShows.LockType = 1; rsUpcomingShows.Open(); var rsUpcomingShows_numRows = 0; %> <% var Repeat1__numRows = -1; var Repeat1__index = 0; rsUpcomingShows_numRows += Repeat1__numRows; %> Creative Cornices | Upcoming Shows

<% var email = String(Request.Form("newsletter")); if(email != "undefined") { var objMail = Server.CreateObject("CDONTS.NewMail"); objMail.From = email; objMail.To = "creativecornices@aol.com"; objMail.Subject = "Newsletter Subscription"; objMail.BCC = "sjbdesigns@aol.com"; objMail.Body = email; objMail.Send(); Response.Write("

Thank you for joining our
newsletter mailing list.

"); newsMail = null; } else { %> <% } %>

Our upcoming shows are...

Upcoming Shows for Barron Designs

<% if (rsUpcomingShows.EOF && rsUpcomingShows.BOF) { %> There are currently no upcoming shows for Creative Cornices™ at this time. <% } // end rsUpcomingShows.EOF && rsUpcomingShows.BOF %>
<% if (!rsUpcomingShows.EOF || !rsUpcomingShows.BOF) { %> <% while ((Repeat1__numRows-- != 0) && (!rsUpcomingShows.EOF)) { %> <% Repeat1__index++; rsUpcomingShows.MoveNext(); } %>

D A T E	T I T L E	L O C A T I O N
<%=(rsUpcomingShows.Fields.Item("Date").Value)%>	<%=(rsUpcomingShows.Fields.Item("Title").Value)%>	<%=(rsUpcomingShows.Fields.Item("Place").Value)%> <%=(rsUpcomingShows.Fields.Item("Location").Value)%>

<% } // end !rsUpcomingShows.EOF || !rsUpcomingShows.BOF %>

<% rsUpcomingShows.Close(); %> <% rsUpcomingShows = null %>