[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2129
  • Last Modified:

Pagination ASP Recordset Show 10 on Page with Page Numbers e.g. 1,2,3

Hi all,
Tried all the examples here on E-E.com to get this simple recordset to show just 10 records on the page with Pagination e.g. 1,2,3 without any success.
The recordset (with my pagination code removed is below)
<%
set rs=openrs("SELECT * FROM News WHERE Active=1 AND EndDate < getdate() ORDER BY TheDate DESC")
if not rs.eof then
rs.movefirst
while not rs.eof
NewsID=rs("NewsID")
TheDate=rs("TheDate")
Summary=rs("Summary")
Title=rs("Title")
%>
<br><%=TheDate%><br><a href="default.asp?NewsID=<%=NewsID%>"><b><%=Title%></b></a>
<%
  rs.movenext
  wend
  end if
  rs.close
  set rs=nothing
%>

Open in new window

0
fgict
Asked:
fgict
1 Solution
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now