<%
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 %>