Paging long articles in Classic ASP

4.14 (7 votes)

Long articles are better broken into bite-sized chunks over several pages. With static HTML, this is easily achieved by dividing the article into logical separations and creating separate .htm files for each. Here's how to do it using ASP for an article that gets posted to a database.

split() returns a one-dimensional zero-based array containing a number of substrings, so it is perfect for this job. What I want to do is take an article (which is a string) and divide it into substrings. In order to do this, I need a delimiter, and I use <!--pagebreak-->. As I enter the article into the database, I place <!--pagebreak--> at the points I want to break the article.

Then, having extracted the article from the database as part of a recordset, and consigned it to the variable article, I use split() to create an array, with each element of the array being a page.

<%
article = "This <!--pagebreak--> is <!--pagebreak--> a <!--pagebreak--> 
paged <!--pagebreak--> article"

Some articles may be small enough not to require paging, so we check to see if this is one that has been divided into pages on entry into the database

 
if instr(article,"<!--pagebreak-->") then
  pages = split(article,"<!--pagebreak-->")

I add 1 to ubound(pages) to take account of the fact that this array is zero based

totalpages = ubound(pages)+1 

I need to keep track of which is the current page

if request.querystring("page") = "" then 
  currentpage = 1
else
  currentpage = cint(request.querystring("page"))
end if
if pageno > totalpages then pageno = totalpages

I write out the contents of the current page of the article - not forgetting that I need to adjust the value by deducting 1 for the zero-based array

 
response.write "<br><strong><font color=""red"">"
& pages(currentpage-1) & "</font></strong><br>" 

And then the links from one page to the next at the bottom.

 
for j = 1 to totalpages
  if j = currentpage then
    response.write "&nbsp;" & j & "&nbsp;"
  else
    response.write "&nbsp;<a href=""article_paging.asp?page=" & _
    & j & """>" & j & "</a>&nbsp;"
  end if
next
end if
%> 

Date Posted:
Last Updated:
Posted by:
Total Views to date: 22020

2 Comments

- TVK5300

My sqlstring is:

strSQL = "SELECT * FROM trainingen RIGHT JOIN ledenlijst USING (bondsnummer,categorie) WHERE month(datum) = " + Cstr(trainmaand)
strSQL = strSQL + " and categorie = '" & reeks & "' order by datum,bondsnummer+0 asc"

When I declare at the beginning of the page trainmaand=8 en reeks="U15", the page works .

But when I retrieve the values of trainmaand and reeks with Request.Form from another page, then it only works for the first page, for the other pages I get an error in the sqlstring.

Is there a way to keep the values that come from Request.Form to be able to scroll all records?

- Mike

@TVK5300

Set the values in hidden fields. Then they get posted along with any others.

<input type="hidden" name="trainmaand" value="<%=trainmaand%>" />

You'll need to add hidden fields for the other pages so that the value can be passed to them as necessary.

Or, you can pass it in a Session variable. By the way, you really should use parameters in your SQL.

Recent Comments

Jon 31/03/2016 21:36
In response to Exploring Prefix: A Free ASP.NET Profiling Tool
We had the exact same experience, finding multiple bugs in an application that we thought was pretty...

ranjith 31/03/2016 05:50
In response to A Better Way To Export Gridviews To Excel
Hello Mike. i am exporting from gridview, because i have some images in my gridview. but i am error...

Matt Watson 30/03/2016 22:19
In response to Exploring Prefix: A Free ASP.NET Profiling Tool
Glad you are loving it! Matt from Stackify...

Dmitry 28/03/2016 04:26
In response to Solved - The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine
thank you about the VS 32-bit remark...

federico 26/03/2016 11:29
In response to Request.Form Is Empty When Posting To ASPX Page
thanks!....

Micheal 23/03/2016 00:58
In response to ASP.NET MVC 5 with EF 6 - Working With Files
Thanks for the code. its pretty straightforward. worked for me on my first trial. Perfect!...

Francisco 22/03/2016 20:35
In response to ASP.NET MVC 5 with EF 6 - Working With Files
The post is very good, thanks...

Nick Brown 22/03/2016 13:53
In response to Adding A View
Hi, Many thanks for this tutorial, it's helping me get started with MVC. In VB (VS 2013) I get late...

ferry mae 22/03/2016 13:04
In response to Send form content by email in ASP.NET
do i need to change this? message.To.Add(new MailAddress("me@domain.com")); message.CC.Add(new you...

Keith 22/03/2016 12:02
In response to Creating a Connection String and Working with SQL Server LocalDB
As always worst explanation, but this time you rocked with plagiarism too .. huhh.. copied from Rick...