<% sql="select * from pdffile where show=1 " set rs=conn.execute(sql) %> Current Issue

<% If rs.eof Then %> There are no current issue. <% Else %> Title: <%= rs("title") %>
Date: <%= rs("upload_date") %>
File: " target="_blank"><%= rs("pdf_file") %>


<% End If %> <% set rs=nothing sql="select * from pdffile where show=0 order by id" set rs=conn.execute(sql) %> Previous Issues

<% If rs.eof then%> There are no previous issues. <% Else %> <% do while not rs.eof %> Title: <%= rs("title")%>
Date: <%= rs("upload_date") %>
File: " target="_blank"><%= rs("pdf_file") %>


<% rs.movenext loop end if %>