www.siraque.com.br

<%@LANGUAGE="VBSCRIPT"%> <% Dim hoje hoje = Date Dim rsAgenda__MMColParam rsAgenda__MMColParam = DoDateTime(hoje, 2, 1033) tmpData = Request.Form("data") if(Request.Form("data") <> "") then rsAgenda__MMColParam = DoDateTime(tmpData, 2, 1033) %> <% set rsAgenda = Server.CreateObject("ADODB.Recordset") rsAgenda.ActiveConnection = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:\private\dados\siraque\siraque.mdb" rsAgenda.Source = "SELECT * FROM Agenda WHERE Data = #" + rsAgenda__MMColParam + "# ORDER BY Inicio" rsAgenda.CursorType = 0 rsAgenda.CursorLocation = 2 rsAgenda.LockType = 3 rsAgenda.Open rsAgenda_numRows = 0 %> <% set Recordset1 = Server.CreateObject("ADODB.Recordset") Recordset1.ActiveConnection = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:\private\dados\siraque\siraque.mdb" Recordset1.Source = "SELECT * FROM Agenda" Recordset1.CursorType = 0 Recordset1.CursorLocation = 2 Recordset1.LockType = 3 Recordset1.Open Recordset1_numRows = 0 %><% set rsDatas = Server.CreateObject("ADODB.Recordset") rsDatas.ActiveConnection = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:\private\dados\siraque\siraque.mdb" rsDatas.Source = "SELECT DISTINCT Data FROM Agenda ORDER BY Data DESC" rsDatas.CursorType = 0 rsDatas.CursorLocation = 2 rsDatas.LockType = 3 rsDatas.Open rsDatas_numRows = 0 %><% Dim Repeat1__numRows Repeat1__numRows = -1 Dim Repeat1__index Repeat1__index = 0 rsAgenda_numRows = rsAgenda_numRows + Repeat1__numRows %> www.siraque.com.br - Agenda

Busca

Área de Interesse

Tipo

Agenda do dia: <%Response.Write Day(rsAgenda__MMColParam) & "/" & Month(rsAgenda__MMColParam) & "/" & Year(rsAgenda__MMColParam) %>

<% While ((Repeat1__numRows <> 0) AND (NOT rsAgenda.EOF)) %> <%if (CDate(rsAgenda.Fields.Item("Fim")) <> CDate("00:00")) then Response.Write " " Response.Write " " end if%>

<% If ( CDate(rsAgenda.Fields.Item("Fim")) = CDate("00:00")) Then Response.Write "às: " Else Response.Write "das: " End If %>	<%= DoDateTime((rsAgenda.Fields.Item("Inicio").Value), 4, 1033) %>
às:	" Response.Write DoDateTime ((rsAgenda.Fields.Item("Fim").Value), 4, 1033) end if %> <% if (CDate(rsAgenda.Fields.Item("Fim")) <> CDate("00:00")) then Response.Write "
Evento	<%=(rsAgenda.Fields.Item("Evento").Value)%>
Local	<%=(rsAgenda.Fields.Item("Local").Value)%>

<% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 rsAgenda.MoveNext() Wend %>

Fabio Taroda