<%@LANGUAGE="VBSCRIPT"%> <% Dim Recordset1 Dim Recordset1_numRows Dim Dah, Color, Color2, Lois Set Recordset1 = Server.CreateObject("ADODB.Recordset") Recordset1.ActiveConnection = MM_twinoaks_STRING Recordset1.Source = "SELECT * FROM LOISSCHEDULE ORDER BY schedDate ASC" Recordset1.CursorType = 0 Recordset1.CursorLocation = 2 Recordset1.LockType = 1 Recordset1.Open() Recordset1_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 Recordset1_numRows = Recordset1_numRows + Repeat1__numRows %> Lois Scott Appearance Schedule & Band Gigs
Lois Scott's Appearance Schedule
View Gigs by Band
<% While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF)) %><% dah=Recordset1.Fields.Item("schedType").Value If dah = "THE KNOBS" Then Color="#FFDDFF" Color2="#76032C" Lois=" " ElseIf dah = "Lois and THE BAILERS" Then Color="#B7E4FF" Color2="#000099" Lois="Lois Scott & the " Else Color="#ffffff" Color2="#000000" Lois="Lois Scott's " End If %> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 Recordset1.MoveNext() Wend %>
<%=Lois%> <%=(Recordset1.Fields.Item("schedType").Value)%>
<%=(Recordset1.Fields.Item("schedTitle").Value)%>
<%= DoDateTime((Recordset1.Fields.Item("schedDate").Value), 1, 1033) %>
<% Dim MyText MyText = Recordset1.Fields.Item("schedDesc").Value MyText =Replace(MyText,vbcrlf,"
") Response.write MyText %>
<%=(Recordset1.Fields.Item("schedLocation").Value)%>
 " target="_blank"><%=(Recordset1.Fields.Item("schedURL").Value)%>
<% If Recordset1.EOF And Recordset1.BOF Then %>

No <%=Request.Form("schedType")%> Gigs Listed Right Now.
Check Back Soon! <% End If ' end Recordset1.EOF And Recordset1.BOF %>

 
Home    Bio    Photos    Guestbook    Band Gigs    My Music    Buy Stuff    Links    Contact                 

<% Recordset1.Close() Set Recordset1 = Nothing %>