Solved

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

Posted on 2007-11-18
3
2,115 Views
Last Modified: 2009-07-29
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
Comment
Question by:fgict
3 Comments
 
LVL 25

Accepted Solution

by:
kevp75 earned 500 total points
ID: 20309788
0
 
LVL 1

Expert Comment

by:Computer101
ID: 21135878
Forced accept.

Computer101
EE Admin
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now