<%@LANGUAGE="VBSCRIPT"%> <% Dim Recordset1 Dim Recordset1_cmd Dim Recordset1_numRows Set Recordset1_cmd = Server.CreateObject ("ADODB.Command") Recordset1_cmd.ActiveConnection = MM_conexaoartigos_STRING Recordset1_cmd.CommandText = "SELECT Autor, Ordem, Título FROM Tabela1" Recordset1_cmd.Prepared = true Set Recordset1 = Recordset1_cmd.Execute Recordset1_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = 10 Repeat1__index = 0 Recordset1_numRows = Recordset1_numRows + Repeat1__numRows %> VII CONATEE

 

<% While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF)) %> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 Recordset1.MoveNext() Wend %>
Autor Ordem Título
<%=(Recordset1.Fields.Item("Autor").Value)%> <%=(Recordset1.Fields.Item("Ordem").Value)%> <%=(Recordset1.Fields.Item("Título").Value)%>
 
<% Recordset1.Close() Set Recordset1 = Nothing %>