<%@LANGUAGE="VBSCRIPT"%> <% Dim Recordset1 Dim Recordset1_cmd Dim Recordset1_numRows Set Recordset1_cmd = Server.CreateObject ("ADODB.Command") Recordset1_cmd.ActiveConnection = MM_Articles_STRING Recordset1_cmd.CommandText = "SELECT ID, issue, [year], department, author, title FROM Results ORDER BY issnumber DESC, title ASC" Recordset1_cmd.Prepared = true Set Recordset1 = Recordset1_cmd.Execute Recordset1_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 Recordset1_numRows = Recordset1_numRows + Repeat1__numRows %> InsideFinishing Articles


InsideFinishing Articles

<% While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF)) %>

"><%=(Recordset1.Fields.Item("title").Value)%>     by <%=(Recordset1.Fields.Item("author").Value)%>
<%=(Recordset1.Fields.Item("department").Value)%>   <%=(Recordset1.Fields.Item("issue").Value)%>, <%=(Recordset1.Fields.Item("year").Value)%>

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

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