主题:  请高手帮我写一个分页程序

zdygh2008

职务:普通成员
等级:1
金币:0.0
发贴:32
#12002/12/14 17:03:02
<%
' *** Edit Operations: declare variables

Dim MM_editAction
Dim MM_abortEdit
Dim MM_editQuery
Dim MM_editCmd

Dim MM_editConnection
Dim MM_editTable
Dim MM_editRedirectUrl
Dim MM_editColumn
Dim MM_recordId

Dim MM_fieldsStr
Dim MM_columnsStr
Dim MM_fields
Dim MM_columns
Dim MM_typeArray
Dim MM_formVal
Dim MM_delim
Dim MM_altVal
Dim MM_emptyVal
Dim MM_i
dim connstr
dim MM_WZ_STRING
set MM_WZ_STRING=server.CreateObject("adodb.connection")
connstr="DBQ="+server.mappath("wz.mdb")+";DRIVER={Microsoft Access Driver (*.mdb)};"
MM_WZ_STRING.Open connstr
%>

<%
If (CStr(Request("MM_delete")) <> "" And CStr(Request("MM_recordId")) <> "") Then

MM_editQuery = "delete from addlink where username='" & Request("MM_recordId") & "'"


response.Write MM_editQuery
Set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = MM_WZ_STRING
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute
    If (MM_editRedirectUrl<>"")Then
    MM_editRedirectUrl="manage.asp"
     Response.Redirect("manage.asp")
     Response.end
    End if
End If
%>
<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_WZ_STRING
Recordset1.Source = "SELECT * FROM addlink"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index

Repeat1__numRows = 15
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%>













<%
While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF))
%>










<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
Recordset1.MoveNext()
Wend
%>

编号

网站名称

网址

邮件信箱

网站内容简介

时间

点击次数
 
<%=(Recordset1.Fields.Item("ID").value)%>
<%=(Recordset1.Fields.Item("username").value)%>
<%=(Recordset1.Fields.Item("HomePage").value)%>
<%=(Recordset1.Fields.Item("Email").value)%>
<%=(Recordset1.Fields.Item("Note").value)%>
<%=(Recordset1.Fields.Item("Time").value)%>
<%=(Recordset1.Fields.Item("Hits").value)%>



">



<%
Recordset1.Close()
Set Recordset1 = Nothing
%>


以上是我做的一个程序。关于连接数库显示记录等等程序,我已经做好显示我删除功能,但还不能做分页显示效果。我的程序规定一页只显示15个记录。如果有更多的记录,怎样编写分页程序?请高手指点迷津。



绿茶

职务:普通成员
等级:8
金币:10.0
发贴:19267
#22002/12/14 20:05:53
搜索以前的贴子



今晚在线

职务:普通成员
等级:3
金币:1.0
发贴:761
#32002/12/15 21:19:40
或者可以看看这个帖子http://www.tol8.com/pages/pages.asp?id=83



ziriyan

职务:普通成员
等级:2
金币:1.0
发贴:303
#42002/12/16 20:19:52
不错~!