<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% Dim Recordset1 Dim Recordset1_numRows Set Recordset1 = Server.CreateObject("ADODB.Recordset") Recordset1.ActiveConnection = MM_MEC_STRING Recordset1.Source = "SELECT TOP 5 * FROM dbo.Eventos Where Data > getdate() ORDER BY Data ASC" Recordset1.CursorType = 0 Recordset1.CursorLocation = 2 Recordset1.LockType = 1 Recordset1.Open() Recordset1_numRows = 0 %> <% Dim Recordset2 Dim Recordset2_numRows Set Recordset2 = Server.CreateObject("ADODB.Recordset") Recordset2.ActiveConnection = MM_MEC_STRING Recordset2.Source = "SELECT * FROM dbo.Eventos ORDER BY Data DESC" Recordset2.CursorType = 0 Recordset2.CursorLocation = 2 Recordset2.LockType = 1 Recordset2.Open() Recordset2_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = 10 Repeat1__index = 0 Recordset1_numRows = Recordset1_numRows + Repeat1__numRows %> <% Dim Repeat2__numRows Dim Repeat2__index Repeat2__numRows = -1 Repeat2__index = 0 Recordset2_numRows = Recordset2_numRows + Repeat2__numRows %> APAB - Associação Portuguesa de Análise Bioenergética
 
 
 
 

Filiada no
 
 
 

Notícias e Eventos

 
<% While ((Repeat2__numRows <> 0) AND (NOT Recordset2.EOF)) %> <% If Not Recordset2.EOF Or Not Recordset2.BOF Then %>

<%=(Recordset2.Fields.Item("Evento").Value)%>
<%=(Recordset2.Fields.Item("Detalhes").Value)%>
<%= DoDateTime((Recordset2.Fields.Item("Data").Value), 2, 2070) %>
"><%=(Recordset2.Fields.Item("Link").Value)%>
<% End If ' end Not Recordset2.EOF Or NOT Recordset2.BOF %> <% Repeat2__index=Repeat2__index+1 Repeat2__numRows=Repeat2__numRows-1 Recordset2.MoveNext() Wend %>
 
 
Notícias e Eventos
  <% If Not Recordset1.EOF Or Not Recordset1.BOF Then %> <% While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF)) %>
<%=(Recordset1.Fields.Item("Evento").Value)%>
<%=(Recordset1.Fields.Item("Detalhes").Value)%>
<%= DoDateTime((Recordset1.Fields.Item("Data").Value), 2, 1030) %>
" target="_blank"><%=(Recordset1.Fields.Item("Link").Value)%>

<% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 Recordset1.MoveNext() Wend %> <% End If ' end Not Recordset1.EOF Or NOT Recordset1.BOF %>

 
 


EFBAP
 
 
 

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