主题:  为什么不能显示分页(请高手看)

zdygh2008

职务:普通成员
等级:1
金币:0.0
发贴:32
#12002/11/22 0:16:34
<%language="vbscript"
set MM_WZ_STRING=server.CreateObject("adodb.connection")
connstr="DBQ="+server.mappath("wz.mdb")+";DRIVER={Microsoft Access Driver (*.mdb)};"
MM_WZ_STRING.Open connstr
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_WZ_STRING
Recordset1.Source = "SELECT * FROM addlink where MM_recordId=1"
Recordset1.Open()
<%pgsize=15
page=request.querystring("page")
Recordset1.pagesize=pgsize
pgnm=Recordset1.pagecount
if page=""or clng(page)<1 then page=1
if clng(page)>pgnm then page=pgnm
if pgnm>0 then Recordset1.absolutepage=page
count=0
do while not Recordset1.eof and count%><%=rs("MM_recordId")%>

<%count=count+1
Recordset1.movenext
loop
Recordset1.close
set Recordset1=nothing
%>
第一页
>最后一页
>下一页
>上一页
上面这一段程序分页显示的。问题是不能在服务器上正常运行,而是找不到该页的错误。
这做几次修改都不行,请高手指点迷津!


<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>




无标题文档






<%
' *** 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
%>



绿茶

职务:普通成员
等级:8
金币:10.0
发贴:19267
#22002/11/22 8:35:44
...
url="job.asp?type=news"
if not rs.eof then%>





共 <%=rs.recordcount%> 条记录 第 <%=page%> 页 共 <%=totalpage%> 页
                     <%
if page=1 then
    response.write "[首页|上一页"
else
    response.write "[首页上一页"
end if
%><%
if page=totalpage then
    response.write "|下一页|尾页]"
else
    response.write "|下一页尾页]"
end if
%>


...
自己对照着看看吧