日期:2014-05-16  浏览次数:20844 次

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