为什么不出结果??(还请各位老师帮忙!!!)
我写了如下的查询代码,访问数据库,并把结果显示在客户端!但是总是不出结果,不知道为什么?还请各位仁兄帮忙!!
<!--#include file="conn.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>按记录编号搜索</title>
</head>
<body>
<center>
<h2>维护记录表</h2>
<table width=60% border=1>
<tr><th>序号<th>记录编号<th>客户id<th>机器编号<th>服务日期<th>到达时间<th>离开时间<th>故障描述<th>故障解决<th>服务费<th>合同内<th>工程师<th>备注<th>收款
<%
dim sqlstr,prid,cuid,rs_main
prid=request.form("prid")
cuid=request.form("cuid")
conn.open connstr
set rs_main=server.createobject("adodb.recordset")
sqlstr="select * from pr where 记录编号='"&prid&"' and 客户id='"&cuid&"'"
set rs_main=conn.Execute(sqlstr)
If not rs_main.EOF Then
' 如果recordset不为空, 则维护记录存在
Session("bolAuthenticated") = True
'将bolAuthenticated 设为True
i=0
'循环读取记录集
do while not rs_main.eof
'i 为序号
i=i+1
response.write "<tr>"
response.write "<td align=center>" &i
'显示客户资料表
response.write"<td>" & rs_main("记录编号")
response.write "<td>" & rs_main("客户id")
response.write "<td>" & rs_main("机器编号")
response.write "<td>" & rs_main("服务日期")
response.write "<td>" & rs_main("到达时间")
response.write "<td>" & rs_main("离开时间")
response.write "<td>" & rs_main("故障描述")
response.write "<td>" & rs_main("故障解决")
response.write "<td>" & rs_main("服务费")
response.write "<td>" & rs_main("合同内")
response.write "<td>" & rs_main("工程师")
response.write "<td>" & rs_main("备注")
response.write "<td>" & rs_main("收款")
rs_main.movenext
loop
response.write "</table>"
rs_main.close
set rs_main=nothing
end if
%>
</table>
</center>
</body>
</html>
表中的字段就是上面输出字段,还请各位仁兄指点迷津!!或者有比这段程序更好的麻烦转告!多谢!!!!