急！Microsoft JET Database Engine (0x80040E10)至少一个参数没有被指定值
ASP设计问题，急急急！哪位高手帮助我啊！我的QQ：77476207错误类型：
Microsoft JET Database Engine (0x80040E10)
至少一个参数没有被指定值。
/search_adv.asp, 第 234 行
浏览器类型：
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Maxthon)
网页：
POST 101 ??? /search_adv.asp
POST Data:
nian=+&xingbie=+&peixunzhuanye=&peixunshijianc=on&hejipeixun=30&hejipeixun2=80&docorxls=&issubmit=yes
代码如下：
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn_fj16.asp"-->
<!--#include file="admin_qx.asp" -->
<% isdl %>
<html xmlns="http://www.
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<style type="text/css">
<!--
.style5 {color: #000000}
body,td,th {
font-size: 13px;
}
table {
word-break:break-all;
}
.STYLE7 {font-size: 16px}
.STYLE1 {color: #FF0000}
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: none;
}
a:active {
text-decoration: none;
}
TD {
FONT: 15px 宋体
}
.style2 {color: #FFFFFF}
-->
</style>
<title>转移培训-培训台账统计</title>
</head>
<body>
<table border="0" width="100%" id="table3" cellspacing="0" cellpadding="0">
<tr>
<td style="font-size: 13px"> </td>
</tr>
<tr>
<td style="font-size: 13px"> 以下为普通查询，请在下拉框中选择查询条件字段：</td>
</tr>
</table>
<form action="xy_list.asp" method="post" name="form2" target="_self" id="form2">
<div align="center">
<table width="398" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFCF31" style="border: 1px none" id="table1">
<tr>
<td class="STYLE2"><div align="center">
<label>
<select name="ziduan" id="ziduan" style="font-family: 宋体; font-size: 9pt; font-style: bold; border-color: #000000; border-width: 1; background-color: #ffffff">
<option value="xingming" style="font-family: 宋体; font-size: 12px; table-layout: fixed; word-break: break-all">选择查找项目(默认为姓名)</option>
<option value="xuehao" style="font-family: 宋体; font-size: 12px; table-layout: fixed; word-break: break-all">档案号</option>
<option value="xingbie" style="font-family: 宋体; font-size: 12px; table-layout: fixed; word-break: break-all">性别</option>
<option value="wenhuachengdu" style="font-family: 宋体; font-size: 12px; table-layout: fixed; word-break: break-all">文化程度</option>
<option value="peixunzhuanye" style="font-family: 宋体; font-size: 12px; table-layout: fixed; word-break: break-all">培训内容</option>
<option value="jiguan" style="font-family: 宋体; font-size: 12px; table-layout: fixed; word-break: break-all">单位</option>
<option value="shenfenzhenghao" style="font-family: 宋体; font-size: 12px; table-layout: fixed; word-break: break-all">职务</option>
<option value="zhuzhi" style="font-family: 宋体; font-size: 12px; table-layout: fixed; word-break: break-all">职级</option>
<option value="jiuyequxiang" style="font-family: 宋体; font-size: 12px; table-layout: fixed; word-break: break-all">单位</option>
<option value="nian" style="font-family: 宋体; font-size: 12px; table-layout: fixed; word-break: break-all">建档年份</option>
</select>
</label>
<span class="STYLE3">关键字:</span>
<input name="key" type="text" id="key" value="<%=key%>" size="15" style="font-size: 9pt; height: 18px; border-color: #cccccc; border-width: 1px; padding: 1px" />
<label>
<span class="STYLE3">
<input type="submit" name="Submit" value="查找" style="font-size: 9pt; height: 18px; border-color: #cccccc; border-width: 1px; padding: 1px">
</span> </label></td>
</tr>
</table>
</div>
</form>
<table border="0" width="100%" id="table2" cellspacing="0" cellpadding="0">
<tr>
<td><font size="2"> 以下为高级查询，条件可任意组合：</font></td>
</tr>
</table>
<p align="center">培训台账统计 <br />
<form id="form1" name="form1" method="post" action="search_adv.asp">
<div align="center">
<table width="770" cellpadding="3" cellspacing="1" bgcolor="#FFCC33">
<tr>
<td bgcolor="#FFFFFF"><div align="justify">建档年度:
<input name="nianc" type="checkbox" id="nianc" value="on" />
<select name="nian" size="1" class="put" id="nian">
<option value=" " selected="selected"> </option>
<option value="2007">2007</option>
<option value="2008">2008</option>
<option value="2009">2009</option>
<option value="2010">2010</option>
<option value="2011">2011</option>
<option value="2012">2012</option>
</select>
</div></td>
<td bgcolor="#FFFFFF">
<div align="left"> 性别:
<input name="xingbiec" type="checkbox" id="xingbiec" value="on" />
<select name="xingbie" size="1" class="put" id="select5">
<option value=" " selected="selected" > </option>
<option value="男" >男</option>
<option value="女">女</option>
</select>
</div></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="justify">培训内容:
<input name="peixunzhuanyec" type="checkbox" id="peixunzhuanyec" value="on" />
<input name="peixunzhuanye" type="text" id="peixunzhuanye" size="10" />
</div></td>
<td bgcolor="#FFFFFF"><div align="justify"><font color="#ECEBED">合计培训课时：<input name="peixunshijianc" type="checkbox" id="peixunshijianc" value="on" />
<input name="hejipeixun" type="text" id="hejipeixun" size="10" />
天</span>到
<input name="hejipeixun2" type="text" id="hejipeixun2" size="10" />天
</font><font color="#FF0000">正在开发中。。。</font></div></td>
</tr>
</table>
<br />
<input type="button" value="查询到页面" name="B122" style="width:80;background-color: #FFCC66; color: #000000; border: 1 solid #00CC00" onClick="subie()"/>
<input type="button" value="输出到word" name="B1" style="width:80;background-color: #FFCC66; color: #000000; border: 1 solid #00CC00" onClick="subword()" />
<input name="docorxls" type="hidden" id="docorxls" />
<input type="button" value="输出到excel" name="B12" style="width:80;background-color: #FFCC66; color: #000000; border: 1 solid #00CC00" onClick="subexcel()" />
<input name="issubmit" type="hidden" id="issubmit" value="yes">
（
注：年度、性别、培训内容<font color="#ECEBED">和时间</font>段均为可选项！）<span class="STYLE1"><br />
<br />
（请谨慎操作！！！）</span></div>
<script language="javascript">
//
function subword()
{
form1.action="search_adv_we.asp";
form1.docorxls.value="doc";
form1.submit();
}
//
function subexcel()
{
form1.action="search_adv_we.asp";
form1.docorxls.value="xls";
form1.submit();
}
function subie()
{
form1.action="search_adv.asp";
form1.submit();
}
</script>
</form>
<%
nian=trim(request("nian"))
nianc=trim(request("nianc"))
xingbie=trim(request("xingbie"))
xingbiec=trim(request("xingbiec"))
peixunzhuanye=trim(request("peixunzhuanye"))
peixunzhuanyec=trim(request("peixunzhuanyec"))
peixunshijianc=trim(request("peixunshijianc"))
hejipeixun=trim(request("hejipeixun"))
hejipeixunc=trim(request("hejipeixunc"))
hejipeixun2=trim(request("hejipeixun2"))
issubmit=trim(request("issubmit"))
if issubmit="yes" then
if nian="" and xingbie="" and peixunzhuanye="" and hejipeixun=""then
response.Write "<script language=javascript>{window.alert('请至少选择一种查询条件！这四种条件均为可选，且可以任意组合。请按确定返回！');window.history.go(-1);}</script>"
response.end
end if
end if
set rs=server.createobject("adodb.recordset")
sql="select * from jlzd321 where ischeck='1' and isrecycle='0'"
if nianc="on" then
sql=sql&" and nian = '" & nian & "'"
sc="年度:"&nian&"｜"
end if
if xingbiec="on" then
sql=sql&"and xingbie like'%"&xingbie&"%'"
sc=sc&"性别:"&xingbie&"｜"
end if
if peixunzhuanyec="on" then
sql=sql & " and peixunzhuanye like '%" & peixunzhuanye & "%'"
sc=sc&"培训内容:"&peixunzhuanye&"｜"
end if
if peixunshijianc="on" then
sql=sql & " and peixunshijian between hejipeixun and hejipeixun2"
aaa=hejipeixun
bbb=hejipeixun2
sc=sc&"培训课时段:"&aaa&"学时到"&bbb&"｜"
end if
if nianc="" and xingbiec="" and peixunzhuanyec="" and peixunshijianc="" then
response.end
end if
sql=sql&" order by nian desc , xingbie asc , xuehao asc , xingming asc"
rs.open sql,conn,1,2
if rs.eof and rs.bof then
response.write "<script language=JavaScript>{window.alert('您的查询条件为："&sc&"，没有符合条件的记录!请按“确定”返回后重新搜索');window.history.go(-1);}</script>"
response.end
end if
allrecord=rs.recordcount
if sc="" then
response.write "您没有选择任何查询条件，此处显示所有记录,共"&allrecord&"条"
end if
if sc<>"" then
response.write "查询条件为："&sc&",符合条件的记录有"&allrecord&"条"
end if
%>
,培训单位(盖章)： 填表人： 日期:<%=DATE%>
<TABLE width=99% border=1 align="center" cellPadding=0 cellSpacing=0
borderColorLight=#6699ff borderColorDark=#ffffff bgcolor="#FFFFFF" style="border-collapse:collapse">
<tr>
<td width="30" height="18" nowrap="nowrap" bgcolor="#FFCC66" align="center" rowspan="2"><div align="center">
<p style="margin-top: 0; margin-bottom: 0">序号</div></td>
<td width="45" nowrap="nowrap" bgcolor="#FFCC66" align="center" rowspan="2">
<p style="margin-top: 0; margin-bottom: 0">档案</p>
<p style="margin-top: 0; margin-bottom: 0">号</td>
<td width="52" nowrap="nowrap" bgcolor="#FFCC66" align="center" rowspan="2">
<p align="center" style="margin-top: 0; margin-bottom: 0">姓名 </p></td>
<td width="33" nowrap="nowrap" bgcolor="#FFCC66" style="font-size: 13px" align="center" rowspan="2">
<p align="center" style="margin-top: 0; margin-bottom: 0">性</p>
<p align="center" style="margin-top: 0; margin-bottom: 0">别 </p></td>
<td width="29" nowrap="nowrap" bgcolor="#FFCC66" style="font-size: 13px" align="center" rowspan="2">
<p style="margin-top: 0; margin-bottom: 0">年<p style="margin-top: 0; margin-bottom: 0">龄</td>
<td width="29" nowrap="nowrap" bgcolor="#FFCC66" style="font-size: 13px" align="center" rowspan="2">
<p style="margin-top: 0; margin-bottom: 0">民族</td>
<td width="29" nowrap="nowrap" bgcolor="#FFCC66" style="font-size: 13px" align="center" rowspan="2">
<p style="margin-top: 0; margin-bottom: 0">单位</td>
<td width="46" nowrap="nowrap" bgcolor="#FFCC66" style="font-size: 13px" align="center" rowspan="2">
<p style="margin-top: 0; margin-bottom: 0">政治</p>
<p style="margin-top: 0; margin-bottom: 0">面貌</td>
<td width="46" nowrap="nowrap" bgcolor="#FFCC66" style="font-size: 13px" align="center" rowspan="2">
<p align="center" style="margin-top: 0; margin-bottom: 0">职务</p></td>
<td width="32" nowrap="nowrap" bgcolor="#FFCC66" align="center" rowspan="2">
<p style="margin-top: 0; margin-bottom: 0">职级</td>
<td width="59" nowrap="nowrap" bgcolor="#FFCC66" style="font-size: 13px" align="center" rowspan="2">
<p style="margin-top: 0; margin-bottom: 0">文化</p>
<p style="margin-top: 0; margin-bottom: 0">程度 </td>
<td width="56" nowrap="nowrap" bgcolor="#FFCC66" align="center" rowspan="2">
<p style="margin-top: 0; margin-bottom: 0">单位</td>
<td width="194" nowrap="nowrap" bgcolor="#FFCC66" align="center" colspan="7">
（年）学时</td>
<td width="25" bgcolor="#FFCC66" align="center" rowspan="2">
<p align="center" style="margin-top: 0; margin-bottom: 0">备注</p></td>
</tr>
<tr>
<td width="28" nowrap="nowrap" bgcolor="#FFCC66" align="center">07</td>
<td width="28" valign="middle" bgcolor="#FFCC66" align="center">
08</td>
<td width="19" nowrap="nowrap" bgcolor="#FFCC66" align="center">
09</td>
<td width="20" nowrap="nowrap" bgcolor="#FFCC66" align="center">
10</td>
<td width="16" nowrap="nowrap" bgcolor="#FFCC66" align="center">
11</td>
<td width="17" nowrap="nowrap" bgcolor="#FFCC66" align="center">
12</td>
<td width="18" nowrap="nowrap" bgcolor="#FFCC66" align="center">
合计</td>
</tr>
<%
do while not rs.eof %>
<TR>
<td height="27" align="left" valign="middle" nowrap="nowrap"><%=count+1%></td>
<td height="27" align="left" valign="middle" nowrap="nowrap"><a href="xy_view_all.asp?ID=<%=rs("ID")%>" target="_bank"><%=rs("xuehao")%></a></td>
<td align="left" valign="middle" nowrap="nowrap"><a href="xy_view_all.asp?ID=<%=rs("ID")%>" target="_bank"><%=rs("xingming")%></a></td>
<td height="22" align="center" style="font-size: 12px"><%=rs("xingbie")%></td>
<td height="22" align="center" style="font-size: 12px"><%=rs("nianling")%> </td>
<td height="22" align="center" style="font-size: 12px"><%=rs("minzu")%> </td>
<td height="22" align="center" style="font-size: 12px"><%=rs("jiguan")%></td>
<td height="22" align="center" style="font-size: 12px"><%=rs("zhengzhimianmao")%></td>
<td height="22" align="center" style="font-size: 12px"><%=rs("shenfenzhenghao")%></td>
<td height="22" align="center" style="font-size: 12px"><%=rs("zhuzhi")%></td>
<td height="22" align="center" style="font-size: 12px"><%=rs("wenhuachengdu")%></td>
<td height="22" align="center" style="font-size: 12px"><%=rs("jiguan")%> </td>
<td height="22" align="center" style="font-size: 12px"><%=rs("peixun07")%></td>
<td height="22" align="center" style="font-size: 12px"><%=rs("peixun08")%></td>
<td height="22" align="center" style="font-size: 12px"><%=rs("peixun09")%></td>
<td height="22" align="center" style="font-size: 12px"><%=rs("peixun10")%></td>
<td height="22" align="center" style="font-size: 12px"><%=rs("peixun11")%></td>
<td height="22" align="center" style="font-size: 12px"><%=rs("peixun12")%></td>
<td height="22" align="center" style="font-size: 12px"><%=rs("hejipeixun")%></td>
<td height="22" align="center" style="font-size: 12px"><%=rs("beizhu")%></td>
<%rs.movenext
count=count+1
loop
%>
</table>
<p> </p>
</body>
</html>
