最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
记录集分页的问题
时间:2022-07-02 23:21:09 编辑:袖梨 来源:一聚教程网
记录集分页的问题
.p_btns { margin: 10px 0 30px 0; }
.p_bar em { line- }
.p_bar a {color: #6774A8; text-decoration:none;}
.p_bar a:hover {text-decoration:underline;}
.p_bar a:link {text-decoration:none;}
.p_bar a:active {text-decoration:underline;}
.p_bar a:visited {text-decoration:none;}
.p_bar {float: left; border: 1px solid #CAD9EA; background: #F7F7F7; line- color: #999; overflow: hidden; }
.p_bar a, .p_bar strong, .p_bar em, .p_bar kbd, #multipage .p_bar em { float: left; padding: 0 8px; line- }
.p_bar a:hover { background-color: #FFF; }
.p_bar strong { font-weight: bold; color: #090; background: #CAD9EA; }
.p_bar a.prev, .p_bar a.next { line- font-family: Verdana, Arial, Helvetica, sans-serif; }
.p_bar a.next { padding: 0 15px; }
.p_bar kbd { border-left: 1px solid #CAD9EA; margin: 0; }
* html .p_bar kbd { padding: 1px 8px; }
.p_bar kbd input { border: 1px solid #CAD9EA; margin-top: 3px !important; * > margin-top: 1px !important; margin: 1px 4px 0 3px; padding: 0 2px; }
.p_bar kbd>input { margin-bottom: 2px; }
<%
Dim StrWhere, Int_ThisPage,int_pagesize,int_totalsize,TableName,SelectFields,OrderFieldName,OrderType
Int_ThisPage = Request.QueryString("page")
int_pagesize = 50 ''每页记录数
int_totalsize = 0 ''记录总数
StrWhere = "channelId=" & Int(Request.QueryString("cid")) 'where条件
If StrWhere = "" Then StrWhere="id>0"
TableName = "jbsite_artlcle" ''表名称
SelectFields = "title,author,content,channelID,classID" ''选择的字段
OrderFieldName ="id" ''排序字段
OrderType="desc" ''排序方式
Dim i, rs, sql
Set rs = Conn.Execute("SELECT count(*) FROM [" & TableName & "] Where " & StrWhere)
int_totalsize = rs(0)
Set rs = Nothing
Set rs = Server.CreateObject("adodb.recordset")
sql = Jumbot.GetSql("*",TableName, OrderFieldName, int_pagesize, Int_ThisPage, OrderType, StrWhere)
rs.Open sql, Conn, 1, 1
If Not rs.EOF Then
For i = 1 To rs.recordcount
循环部分
rs.MoveNext()
Next
End If
rs.Close
Set rs = Nothing
''分页导航
Response.Write(AutoGoPList(int_totalsize, int_pagesize, Int_ThisPage))
%>
相关文章
- 王者荣耀侦探能力大测试攻略 王者荣耀侦探能力大测试怎么过 11-22
- 无期迷途主线前瞻兑换码是什么 11-22
- 原神欧洛伦怎么培养 11-22
- 炉石传说网易云音乐联动怎么玩 11-22
- 永劫无间手游确幸转盘怎么样 11-22
- 无期迷途主线前瞻兑换码是什么 无期迷途主线前瞻直播兑换码介绍 11-22