X
xw1980
Unregistered / Unconfirmed
GUEST, unregistred user!
代码如下:
<html>
<head>
<title>无标题文档</title>
<meta http-equiv="Content-Type" content="text/html;
charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<%
con="filedsn=xw.dsn"
set conn=server.CreateObject ("adodb.connection")
conn.Open con,"sa","xw"
set rsDept=server.CreateObject ("adodb.recordset")
sql_dept="select [1998].* from 1998;"
rsdept.CursorLocation =1
set rsdept=conn.Execute (sql_dept)
'rsdept.Open Sql_Dept,conn,3,3,1
rsDept.PageSize =1
rsdept.MoveFirst
for each xw in rsdept.Fields
Response.Write xw.name
next
Response.Write "<br>"&rsdept.RecordCount
Response.Write "<br>"&rsdept.PageCount
Response.Write "<br>"&rsdept.PageSize
%>
</body>
</html>
其中,RECORDSET的RECORDCOUNT是-1,而数据记录又是可以取得的,当然不为0或-1
各位大哥请帮小弟一把,
其他一些(论坛上的)关于分页的代码我也试过,同样是不行的
看问题是否出在服务器配置上。
我的配置是:WIN2000 SERVER+IE5.5
<html>
<head>
<title>无标题文档</title>
<meta http-equiv="Content-Type" content="text/html;
charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<%
con="filedsn=xw.dsn"
set conn=server.CreateObject ("adodb.connection")
conn.Open con,"sa","xw"
set rsDept=server.CreateObject ("adodb.recordset")
sql_dept="select [1998].* from 1998;"
rsdept.CursorLocation =1
set rsdept=conn.Execute (sql_dept)
'rsdept.Open Sql_Dept,conn,3,3,1
rsDept.PageSize =1
rsdept.MoveFirst
for each xw in rsdept.Fields
Response.Write xw.name
next
Response.Write "<br>"&rsdept.RecordCount
Response.Write "<br>"&rsdept.PageCount
Response.Write "<br>"&rsdept.PageSize
%>
</body>
</html>
其中,RECORDSET的RECORDCOUNT是-1,而数据记录又是可以取得的,当然不为0或-1
各位大哥请帮小弟一把,
其他一些(论坛上的)关于分页的代码我也试过,同样是不行的
看问题是否出在服务器配置上。
我的配置是:WIN2000 SERVER+IE5.5