 |
|
|
 首页 |
名片设计 CorelDRAW Illustrator AuotoCAD Painter 其他软件 Photoshop Fireworks Flash |
|
1<%@Language = "VBScript" Codepage = "936"%> 2<% 3\\\'分页sql语句生成代码 4Function GetPageSql(TblName,FldName,PageSize,PageIndex,OrderType,StrWhere) 5 Dim StrTemp,StrSql,StrOrder 6 \\\'根据排序方法生成相关代码 7 If OrderType = 0 Then 8 StrTemp = "> (Select Max([" & FldName & "])" 9 StrOrder = " Order By [" & FldName & "] Asc" 10 Else 11 StrTemp = "< (Select Min([" & FldName & "])" 12 StrOrder = " Order By [" & FldName & "] Desc" 13 End If 14 15 \\\'若是第1页则无须复杂的语句 16 If PageIndex = 1 Then 17 StrTemp = "" 18 If StrWhere <> "" Then 19 Strtmp = " Where " & StrWhere 20 End If 21 StrSql = "Select Top " & PageSize & " * From [" & TblName & "]" & Strtmp & StrOrder 22 Else \\\'若不是第1页，构造sql语句 23 StrSql = "Select Top " & PageSize & " * From [" & TblName & "] Where [" & FldName & "]" & StrTemp & _ 24 " From (Select Top " & (PageIndex-1) * PageSize & " [" & FldName & "] From [" & TblName & "]" 25 If StrWhere <> "" Then 26 StrSql = StrSql & " Where " & StrWhere 27 End If 28 StrSql = StrSql & StrOrder & ") As Tbltemp)" 29 If StrWhere <> "" Then 30 StrSql = StrSql & " And " & StrWhere 31 End If 32 StrSql = StrSql & StrOrder 33 End If 34 GetPageSql = StrSql \\\'返回sql语句 35End Function 36Response.Write(GetPageSql("Message","MessageID",10,1,0,"")) 37%> 返回类别: 教程 上一教程: ASP事务处理 下一教程: 用.NET开发ASP组件 您可以阅读与"ASP构造大数据量的分页SQL语句"相关的教程: · 通用的分页类(不执行SQL,直接绑定数据) · 一条SQL语句搞定数据库分页 · 一条SQL 语句搞定数据库分页 · ASP中使用SQL语句操作数据库 · ASP连接SQL SERVER2000数据库例程 |
  |
| 快精灵印艺坊 版权所有 |
首页 会员中心在线印刷在线编辑付款方式索取样品设计指南连锁门店
|
||
