急!用ASP在先查询!求教?
我在frantpage网页上实现一个简单的查询!并把查询的结果分页显示!
以下是我的代码,不知道哪里有错!
<%if request("submit")="查询" then
staffno1=request("t1");
dbconn=Server.CreateObject("ADODB.Connection");
dbconn.open("DSN=vendors;UID=sa;PWD=123456");
rs=Server.createobject("ADODB.recordset");
var sqlstr="select * from vendors where vendor_name='"&staffno1&"' ";
rs.open(sqlstr,dbconn,1);
if(rs.recordcount<1)
{
msgbox "无符合条件记录!";
}
else{
response.write("<P><center><B>数据查询结果</B></center></P>");
response.write("<tr><td><b>ID</b></td><td><b>vendor_name</b></td><td><b>product</b></td>");
for(var i=1;i<=rs.pagesize;i++)
{ if(!rs.Eof) {
response.write("<td><span style='font-size:9t'>"+rs("ID")+"</span></td>");
response.write("<td><span style='font-size:9t'>"+rs("vendor_name")+"</span></td>");
response.write("<td><span style='font-size:9t'>"+rs("product")+"</span></td>");
response.write("</tr>");
rs.movenext();
}
else break;
}
response.write("</table></form>");
rs.close();
dbconn.close();
</script>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>供应商查询</title>
</head>
<body>
<p>
<BR>
<p><font size="6" color="#008000"><b><i>供应商查询</i></b></font></p>
<p> </p>
<p><font size="3" color="#000000"><b>请输入产品名称:</b></font></p>
<form method="POST" action="--WEBBOT-SELF--">
<!--webbot bot="SaveResults" U-File="fpweb:///_private/form_results.txt"
S-Format="TEXT/CSV" S-Label-Fields="TRUE" --><p><input type="text" name="T1" size="20"><input type="submit" value="查询" name="submit"></p>
</form>
<p> </p>
</body>
</html>