头痛了也不明白是怎么一回事,帮忙看看吧
运行demo.asp出现以下错误:
错误类型:
ADODB.Recordset (0x800A0BB9)
参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。
/onepage.asp, 第 11 行
onepage.asp
<%
Sub ShowOnePage(rs,Page)
Response.Write "<CENTER><TABLE BORDER=1>"
Response.Write "<TR BGCOLOR=#00FFFF>"
Response.WRITE "<TD>编号</TD>"
For i=0 to rs.Fields.Count-1
Response.WRITE "<TD>" & rs.Fields(i).Name & "</TD>"
Next
Response.Write "</TR>"
rs.AbsolutePage = Page
For iPage = 1 To rs.PageSize
Response.Write "<TR>"
RecNo = (Page - 1) * rs.PageSize + iPage
Response.Write "<TD>" & RecNo & "</TD>"
For i=0 to rs.Fields.Count-1
Response.WRITE "<TD>" & rs.Fields(i).Value & "</TD>"
Next
Response.Write "</TR>"
rs.MoveNext
If rs.EOF Then Exit For
Next
Response.Write "</TABLE></CENTER>"
End Sub
%>
<html>
<head>
<meta http-equiv="Content-Type"
content="text/html; charset=gb_2312-80">
<meta name="GENERATOR" content="Microsoft FrontPage Express 2.0">
<title></title>
</head>
<body>
</body>
</html>
demo.asp
<!--#include file="onepage.asp" -->
<!--#include file="adovbs.inc" -->
<%
'打开数据库
set conn = server.CreateObject("ADODB.Connection")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq="&server.MapPath("test.mdb")
set rs = server.CreateObject("ADODB.Recordset")
sql="test"
rs.open sql,conn,3
%>
<html>
<head>
<title>学生档案管理系统演示程序</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<center><font=4>学生档案管理系统演示程序</center></font>
<hr>
<%
rs.pagesize=5
page = clng(request("page"))
if page < 1 then pgae=1
if page > rs.pagecount then page = rs.pagecount
ShowOnePage rs,Page
%>
<%
If Page <> 1 Then
Response.Write "<A HREF=Pagev3.asp?Page=1>第一页</A>"
Response.Write "<A HREF=Pagev3.asp?Page=" & (Page-1) & ">上一页</A>"
End If
If Page <> rs.PageCount Then
Response.Write "<A HREF=Pagev3.asp?Page=" & (Page+1) & ">下一页</A>"
Response.Write "<A HREF=Pagev3.asp?Page=" & rs.PageCount & ">最后一页</A>"
End If
%>
</body>
</html>