原代码如下:
现在一页只显示一条记录,也删除不掉己有的记录.想改成:每一页显示20条记录的.再可以把先前发布的信息删除.如何改?
<%
conn.close
set conn=nothing
Function TalentsList()
Dim idCount
Dim pages
pages = 20
Dim pagec
Dim page
page = CLng(request("Page"))
Dim pagenc
pagenc = 2
Dim pagenmax
Dim pagenmin
Dim datafrom
datafrom = "Qianbo_Talents"
Dim datawhere
If Result = "Search" Then
datawhere = "where TalentsName like '%" & Keyword &_
"%' "
Else
If SortPath<>"" Then
datawhere = "where Instr(SortPath,'"&SortPath&"')>0 "
Else
datawhere = ""
End If
End If
Dim sqlid
Dim Myself, PATH_INFO, QUERY_STRING
PATH_INFO = request.servervariables("PATH_INFO")
QUERY_STRING = request.ServerVariables("QUERY_STRING")'
If QUERY_STRING = "" Or InStr(PATH_INFO & "?" & QUERY_STRING, "Page=") = 0 Then
Myself = PATH_INFO & "?"
Else
Myself = Left(PATH_INFO & "?" & QUERY_STRING, InStr(PATH_INFO & "?" & QUERY_STRING, "Page=") -1)
End If
Dim taxis
taxis = "order by id desc"
Dim i
Dim rs, sql
sql = "select count(ID) as idCount from ["& datafrom &"]" & datawhere
Set rs = server.CreateObject("adodb.recordset")
rs.Open sql, conn, 0, 1
idCount = rs("idCount")
If(idcount>0) Then
If(idcount Mod pages = 0)Then
pagec = Int(idcount / pages)
Else
pagec = Int(idcount / pages) + 1
End If
sql = "select id from ["& datafrom &"] " & datawhere & taxis
Set rs = server.CreateObject("adodb.recordset")
rs.Open sql, conn, 1, 1
rs.pagesize = pages
If page < 1 Then page = 1
If page > pagec Then page = pagec
现在一页只显示一条记录,也删除不掉己有的记录.想改成:每一页显示20条记录的.再可以把先前发布的信息删除.如何改?
<%
conn.close
set conn=nothing
Function TalentsList()
Dim idCount
Dim pages
pages = 20
Dim pagec
Dim page
page = CLng(request("Page"))
Dim pagenc
pagenc = 2
Dim pagenmax
Dim pagenmin
Dim datafrom
datafrom = "Qianbo_Talents"
Dim datawhere
If Result = "Search" Then
datawhere = "where TalentsName like '%" & Keyword &_
"%' "
Else
If SortPath<>"" Then
datawhere = "where Instr(SortPath,'"&SortPath&"')>0 "
Else
datawhere = ""
End If
End If
Dim sqlid
Dim Myself, PATH_INFO, QUERY_STRING
PATH_INFO = request.servervariables("PATH_INFO")
QUERY_STRING = request.ServerVariables("QUERY_STRING")'
If QUERY_STRING = "" Or InStr(PATH_INFO & "?" & QUERY_STRING, "Page=") = 0 Then
Myself = PATH_INFO & "?"
Else
Myself = Left(PATH_INFO & "?" & QUERY_STRING, InStr(PATH_INFO & "?" & QUERY_STRING, "Page=") -1)
End If
Dim taxis
taxis = "order by id desc"
Dim i
Dim rs, sql
sql = "select count(ID) as idCount from ["& datafrom &"]" & datawhere
Set rs = server.CreateObject("adodb.recordset")
rs.Open sql, conn, 0, 1
idCount = rs("idCount")
If(idcount>0) Then
If(idcount Mod pages = 0)Then
pagec = Int(idcount / pages)
Else
pagec = Int(idcount / pages) + 1
End If
sql = "select id from ["& datafrom &"] " & datawhere & taxis
Set rs = server.CreateObject("adodb.recordset")
rs.Open sql, conn, 1, 1
rs.pagesize = pages
If page < 1 Then page = 1
If page > pagec Then page = pagec
