ASP+Access至少一个参数没有被指定值2
<!--#include file="connection.asp"--><body bgcolor="#E1F1E4">
<%
id=session("id")
'pw=session("pw")
conn.Open ConnStr
set rs=server.createobject("adodb.recordset")
sql="select * from loginmima where name='"&id&"'"
set rs=conn.execute(sql)
if not rs.eof then
session("id")=id
'session("pw")=pw
else%>
<script language="VBScript">
alert("对不起,您尚未登录或登录超时,请先登录!")
location.href="index.asp"
</script>
<%
response.end
end if
%>
<%
'conn.Open ConnStr
'set rs=server.CreateObject("adodb.recordset")
biao=session("biao")
f_name=session("f_name")
xname=session("name")
f_sex=session("f_sex")
sex=session("sex")
f_chushengfanwei=session("f_chushengfanwei")
chushengy1=session("y1")
chushengy2=session("y2")
f_diqu=session("f_diqu")
diqu=session("diqu")
f_canjileibie=session("f_canjileibie")
canjileibie=session("canjileibie")
f_canjidengji=session("f_canjidengji")
canjidengji=session("canjidengji")
yy1=session("tjyy1")
yy2=session("tjyy2")
strsql="select "&session("biao")&"."&session("biao")&"_year,count(*) as summ from disableman,"&session("biao")&" where disableman.残疾人证号="&session("biao")&"."&session("biao")&"_cjzh "
if(session("f_sex")="f_sex") then
strsql=strsql&" and disable.性别="&sex&" "
end if
if(session("f_chushengfanwei")="f_chushengfanwei") then
if session("y1")<session("y2") then
strsql=strsql&" and (left(disableman.出生年月,4)>="&session("y1")&" and left(disableman.出生年月,4)<="&session("y2")&" ) &nbs