奇怪，奇怪，真奇怪！求助.在线等待

[sunefeeling]

我的代码如下
<form name="form1" method="post" action="popdingdan.asp">
<div align="center">
<select name="month1">
<% for i=1 to month(now())%>
<option value="<%=i%>" select select><%=i%></option>
<%next%>
</select>
月---
<select name="month2">
<% for j=1 to month(now())%>
<option selected value="<%=j%>"><%=j%></option>
<%next%>
</select>
月
<select name="zhuangtai">
<option value="" selected>请选择定单状态</option>
<option value="2">订阅网确认定单</option>
<option value="3">已收款的定单</option>
<option value="4">执行定单</option>
</select>
     
<input type="submit" name="Submit" value="输出为EXCEL电子表格">
</div>
</form>
在popdingdan.asp中有如下代码：
Response.ContentType = "application/vnd.ms-excel"
dim m1,m2,zhuangtai
m1=int(request("month1"))
m2=int(request("month2"))
zhuangtai=request("zhuangtai")
......
select case zhuangtai

case "2"
set RS=conntemp.execute("select * from shop_action where int(month(actiondate))>=2 and int(month(actiondate))<=3 and zhuangtai=2 and actiondate<>null order by actiondate desc ")
case "3"
set RS=conntemp.execute("select * from shop_action where int(month(actiondate))>=2 and int(month(actiondate))<=3 and zhuangtai>=3 and actiondate<>null order by actiondate desc ")
case "4"
set RS=conntemp.execute("select * from shop_action where int(month(actiondate))>=2 and int(month(actiondate))<=3 and zhuangtai=4 and actiondate<>null order by actiondate desc ")
end select
好象在这两个页面中，数值并没有传递一样，无论我选择状态栏里的哪个状态，都始终执行一条语句，我什么地方错了吗，请教各位高手。

[sunefeeling]

上面的select 语句应该是
select case zhuangtai

case "2"
set RS=conntemp.execute("select * from shop_action where int(month(actiondate))>="&m1&" and int(month(actiondate))<="&m2&" and zhuangtai=2 and actiondate<>null order by actiondate desc ")
case "3"
set RS=conntemp.execute("select * from shop_action where int(month(actiondate))>="&m1&" and int(month(actiondate))<="&m2&" and zhuangtai>=3 and actiondate<>null order by actiondate desc ")
case "4"
set RS=conntemp.execute("select * from shop_action where int(month(actiondate))>="&m1&"and int(month(actiondate))<="&m2&" and zhuangtai=4 and actiondate<>null order by actiondate desc ")
end select