错误提示：
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC Microsoft Access Driver] 日期的语法错误 在查询表达式 'sqgw Like '%%' and Birthday between #1950-1-1# and ##' 中。
/web-2005/find/comsearchlist.asp，行40
源代码：<% session timeout=1
if request.Form("age1")="" then
session("cc")=#1950-1-1#
else
if request.Form("age1")<>"" then session("cc")=request.Form("age")
end if
if request.Form("condition1")<>"" and request.Form("bachelor1")="" then
session("aa")=request.Form("sex")
session("ee")=request.Form("nationality")
session("ff")=request.Form("huji")
session("bb")=request("job")
session("dd")=request("edate")
sql="SELECT * FROM humanresource WHERE nationality='" + session("ee") + "' and huji= '" + session("ff") + "' and sqgw Like '%" & session("bb") & "%' and sex= '" + session("aa") + "' and Birthday between #"&session("cc")&"# and #"&session("dd")&"# "
else
if request.Form("condition1")="" and request.Form("bachelor1")="" then
sql="SELECT * FROM humanresource WHERE sqgw Like '%" & session("bb") & "%' and Birthday between #"&session("cc")&"# and #"&session("dd")&"# "
end if
end if
if request.Form("condition1")<>"" and request.Form("bachelor1")<>"" then
session("gg")=request("bachelor")
sql="SELECT * FROM humanresource WHERE nationality='" + session("ee") + "' and huji= '" + session("ff") + "' and sqgw Like '%" & session("bb") & "%' and sex= '" + session("aa") + "' and Birthday between #"&session("cc")&"# and #"&session("dd")&"# and bachelor= '" + session("gg") + "'"
else
if request.Form("condition1")="" and request.Form("bachelor1")<>"" then
sql="SELECT * FROM humanresource WHERE sqgw Like '%" & session("bb") & "%' and Birthday between #"&session("cc")&"# and #"&session("dd")&"# and bachelor= '" + session("gg") + "' "
end if
end if
set rs_search=Server.CreateObject("ADODB.RecordSet")
rs_search.open sql,conn,1,3
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>复合搜索</title>
<style>
<!--
td { font-size: 9pt;font_name:宋体;; line-height: 16pt}
a:hover { color: #ff0000; text-decoration: underline; font-size: 9pt }
a { font-size: 9pt; color: #0000FF; text-decoration: none }
p { font-size: 9pt; font-family: "宋体"; line-height: 11pt}
a:link {
color: #333333;
}
.style1 {color: #666666}
.style3 {color: #333333}
-->
</style>
</head>
<body bgcolor="dddddd">
<div align="center">
<table width="567" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="567" height="21" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="52" height="21" align="center" valign="top" class="style1" bgcolor="#999999"><strong>编号</strong></td>
<td width="35" align="center" valign="top" class="style1" bgcolor="#AAAAAA"><strong>性别</strong></td>
<td width="76" align="center" valign="top" bgcolor="#999999" class="style1"><strong>出生日期</strong></td>
<td width="70" align="center" valign="top" bgcolor="#AAAAAA" class="style1"><strong>籍贯</strong></td>
<td width="70" align="center" valign="top" bgcolor="#999999" class="style1"><strong>户口</strong></td>
<td width="46" align="center" valign="top" bgcolor="#AAAAAA" class="style1"><strong>学历</strong></td>
<td width="60" align="center" valign="top" bgcolor="#999999" class="style1"><strong>婚姻状况</strong></td>
<td width="60" align="center" valign="top" bgcolor="#AAAAAA" class="style1"><strong>健康状况</strong></td>
<td width="98" align="center" valign="top" bgcolor="#999999" class="style1" ><strong>查看详细信息</strong></td>
</tr>
</table></td>
</tr>
<tr>
<% if rs_search.eof then%>
<script language="javascript">
alert("无符合条件的内容！")
history.back(1)
</script>
<%response.end()
end if
'分页'
rs_search.pagesize=9
page=CLng(Request("page"))
if page<1 then page=1
rs_search.absolutepage=page
for i=1 to rs_search.pagesize %>
<td height="21" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="52" height="21" align="center" valign="top" bgcolor="#BEBEBE"><%=rs_search("ID")%></td>
<td width="35" align="center" valign="top" bgcolor="#C9C9C9"><div align="center"><%=rs_search("SEX")%></div></td>
<td width="76" align="center" valign="top" bgcolor="#BEBEBE"><%=rs_search("BIRTHDAY")%></td>
<td width="70" align="center" valign="top" bgcolor="#C9C9C9"><div align="center"><%=rs_search("nATIONALITY")%></div></td>
<td width="70" align="center" valign="top" bgcolor="#BEBEBE"><%=rs_search("HUJI")%></td>
<td width="46" align="center" valign="top" bgcolor="#C9C9C9"><%=rs_search("BACHELOR")%></td>
<td width="60" align="center" valign="top" bgcolor="#BEBEBE"><%=rs_search("MARRIAGE")%></td>
<td width="60" align="center" valign="top" bgcolor="#C9C9C9"><%=rs_search("HEALTH")%></td>
<td width="98" align="center" valign="top" bgcolor="#BEBEBE"><a href="detail.asp?ID=<%= rs_search("ID") %>" target="_blank">详细信息<a/></td>
</tr>
</table></td>
</tr>
<%rs_search.movenext
total=total+1
if rs_search.eof then exit for
next %>
<tr>
<td height="21" valign="top"> <table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="349" height="21" valign="top" class="style1">
<% if page<>1 then %> <a href=<%=path%>?page=1 class="l">第一页</a>
<a href=<%=path%>?page=<%=(page-1)%> class="l">上一页</a>
<%end if
if page<>rs_search.pagecount then %>
<a href=<%=path%>?page=<%=(page+1)%> class="l">下一页</a>
<a href=<%=path%>?page=<%=rs_search.pagecount%> class="l">最后一页</a>
<%end if %>
<td width="218" valign="top" class="style1"><div align="right">
<% If Not rs_search.EOF Or Not rs_search.BOF Then '显记录导航信息%>
<font color="#00CCFF" class="style3">从 <%=(page-1)*3+1%> 到 <%=(page-1)*3+total%> 共
<%=rs_search.recordcount%></font> <span class="style3">条记录</span>
<% End If %>
</div>
</tr>
</table>
