救命亚 这个我弄了好几天了 还是分页错误(手写代码的 大家帮帮我)就是只能点一下就不行了
<%@ LANGUAGE="VBSCRIPT" %>
<%
a=request("a")
b=request("b")
bm=request("class")
CurrPage=request("CurrPage")
DBQ ="d:\webhosting\clients\max5\database\bookshop.MDB"
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & DBQ
set rs=server.createobject("adodb.recordset")
sql = "Select * From book Where class2='"& bm &"' order by bookbm"
'rs.open sql,conn,1,1
rs.open sql,conn,adOpenkeyset,adlockoptimistic,adcmdtext
if rs.RecordCount<=0 then
response.write "数据库没有符合条件的数据"
response.end
else
i=0
rs.PageSize=10
end if
PageCount=clng(rs.PageCount)
if CurrPage>PageCount then
CurrPage=PageCount
end if
if CurrPage<=0 or CurrPage="" then
CurrPage=1
end if
BookNum=rs.RecordCount
rs.absolutePage = CurrPage
%>
: E L E N E S H O P :