Question

ASP数据统计问题，谁能帮我改改

我做一个查询，想根据FORM1中的年限不同查不同的数据，然后输出count1，count2，count3
我想写的程序如下，可总是出错！！！谁能帮我解决一下，另外想找个ASP高手为师，QQ8517880
<%
dayid=trim(request("dayid"))
dim count1
dim count2
dim count3
if dayid="" then
set rs1=server.CreateObject("adodb.recordset")
sql1="select * from jlzd321 where ischeck='1' and isrecycle='0'"
rs1.open sql1,conn,1,1
set rs2=server.CreateObject("adodb.recordset")
sql2="select * from jlzd321 where ischeck='1' and isrecycle='0' and kskhcjkaohe1='转入'"
rs2.open sql2,conn,1,1
set rs3=server.CreateObject("adodb.recordset")
sql3="select * from jlzd321 where isrecycle='1'"
rs3.open sql3,conn,1,1
count1=rs1.recordcount
count2=rs2.recordcount
count3=rs3.recordcount
else
set rs4=server.CreateObject("adodb.recordset")
sql4="select * from jlzd321 where ischeck='1' and isrecycle='0' and nian="&dayid&""
rs4.open sql4,conn,1,1
set rs5=server.CreateObject("adodb.recordset")
sql5="select * from jlzd321 where ischeck='1' and isrecycle='0' and kskhcjkaohe1='转入' and nian="&dayid&""
rs5.open sql5,conn,1,1
set rs6=server.CreateObject("adodb.recordset")
sql6="select * from jlzd321 where isrecycle='1' and nian="&dayid&""
rs6.open sql6,conn,1,1
count1=rs4.recordcount
count2=rs5.recordcount
count3=rs6.recordcount
end if
%>

<form id="form1" name="form1" method="post" action="">
一、<select name="dayid" size="1" class="put" id="dayid" onChange='window.location=form1.dayid.options[form1.dayid.selectedIndex].value'>
<option value="<%=dayid%>"><%=dayid%></option>
<%for i=year(date) to 2004 step -1%>
<option value="first.asp?dayid=<%=i%>"><%=i%></option>
<%next%>
</select>
年底总数</form>
如果不选年份，就查询所以记录，关键是我那个变量dayid不知道那么搞好了！！！！！
dayid不是数据库中的，是我自己搞的变量！

Answer 1

不知你的dayid在数据库中是个什么类型的字段，查询的时候注意字段类型要一致

Answer 2

解决:)