我做了一个成绩查询,从首页递交过来两个字段yz_number \yz_name,分别是准考证和姓名,然后进行查询成绩,
这是我查询页面的代码,帮我看看哪出问题了
--------------------------------------
<%
yz_number=request("yz_number")
yz_name=request("yz_name")
if yz_number="" then
response.write "<script>alert('准考证与姓名必须要填写！');history.back();</Script>"
response.end
end if
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>Untitled Document</title>
<style type="text/css">
<!--
.style1 {
font-size: 11pt;
color: #FFFFFF;
font-weight: bold;
}
-->
</style>
</head>
<body>
<p> </p>
<p> </p>
<p> </p>
<table width="492" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#0099FF">
<%
dim conn,connstr
on error resume next
connstr="DBQ="+server.mappath("data/123.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
Set conn=Server.CreateObject("ADODB.CONNECTION")
conn.open connstr
Set rs= Server.CreateObject("ADODB.Recordset")
sql="select * from num where yz_number='"& yz_number &"' and yz_name='"& yz_name &"'"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "<script>alert('没有找到相关数据');history.back();</Script>"
else
%>
<tr>
<td height="30" bgcolor="#0066CC"><div align="center" class="style1">你的成绩公布如下</div></td>
</tr>
<tr>
<td height="30" bgcolor="#FFFFFF"><%=rs("yz_cj")%></td>
</tr>
<%
end if
rs.close
set rs=nothing
%>
</table>
</body>
</html>
------------------------------------
我输入了正确的准考证和姓名,但是它还是提示没有找到相关数据,疯了,简单的问题复杂化了,请帮忙看看,
