分页输出
数据库表为test表中有十条记录
为何输出的结果都为-1,-1 ????
- VBScript code
'测试读取MySql数据库的内容const adopenstatic=3const adlockpessimistic=2strconnection="driver={mysql odbc 5.1 driver};database=test;server=localhost;uid=root;password=dubu"'无需配置dsnset conn = server.createobject("adodb.connection") conn.open strconnectionresponse.write "连接成功"&"<p>"set rconn=server.CreateObject("adodb.recordset")rconn.open "test",conn,adopenstatic,adlockpessimisticrconn.pagesize=5response.Write "记录总数"&rconn.recordcountresponse.Write "总页数"&rconn.pagecount[解决办法]
rconn.open 前加 rconn.cursorLocation = 3