%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
set rs1=server.createobject("adodb.recordset")
sqltext1="select * from year order by year"
rs1.open sqltext1,testconn,1,1
datestring=Date()
getyear=mid(datestring,1,4)
lastyear1=getyear-1
set thisyear=server.createobject("adodb.recordset")
sqltext="select * from contestname where status='完全存档' "&" and year='"&getyear&"'"
thisyear.open sqltext,testconn,1,1
set lastyear=server.createobject("adodb.recordset")
sqltext2="select * from contestname where status='完全存档' "&" and year='"&lastyear1&"'"
lastyear.open sqltext2,testconn,1,1
%>