You are viewing a list of all John's scheduled shows. You may also switch to a monthly view.

<% strValSQL = "SELECT * FROM Calendar ORDER BY CaDate;" Set objConn = Server.CreateObject("ADODB.Connection") Set objRec = Server.CreateObject("ADODB.Recordset") objConn.Open strConnect objRec.Open strValSQL, objConn, 3,, 1 While NOT objRec.EOF Response.Write "
• " & objRec("CaDate") & " - " & objRec("CaCity") & " [ details ]
" objRec.movenext Wend objRec.Close objConn.Close %>