Paging long articles in Classic ASP

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: Saturday, March 31, 2007 5:46 PM
Last Updated:
Posted by: Mikesdotnetting
Total Views to date: 20917

2 Comments

Tuesday, August 10, 2010 5:32 PM - 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?

Wednesday, August 11, 2010 6:40 PM - 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.
Add your comment

If you have any comments to make about this article, please use this form to do so. Make sure that your comment relates specifically to the article above. More general comments can be posted through the form on the Contact page.

Please note, all comments are moderated, and some may not be published. The kind of things that will ensure your comment is deleted without ever seeing the light of day are as follows:

  • Not relevant to the article
  • Gratuitous links to your own site or product
  • Anything abusive or libellous
  • Spam
  • Anything in a language I don't understand including gibberish.

I do not pass email addresses on to spammers, so a valid one will assist me in responding to you personally if required.

Recent Comments

Satyabrata 1/23/2015 6:02 AM
In response to Usage of the @ (at) sign in ASP.NET
Refreshed a lot of things.Thanks...

Vo Thanh Chinh Trung 1/22/2015 4:30 PM
In response to Adding A View
It's very helpful...Thank you so much, Mikes!...

Joop Stringer 1/22/2015 12:00 PM
In response to Inline Editing With The WebGrid
How to add a row for a new record ?...

Gaetan C 1/21/2015 8:49 PM
In response to Looking At The WebMatrix WebGrid
I use the webgrid very often and I Wonder if it's possible to merge to different sql query into on...

Teresa 1/19/2015 3:08 PM
In response to MVC 5 with EF 6 in Visual Basic - Creating an Entity Framework Data Model
At the top, the first thing you write is "Open Visual Studio and create a new C# Web project named I...

Evita 1/19/2015 6:44 AM
In response to Creating a Connection String and Working with SQL Server LocalDB
Hi Mike, Thank you so much for the tutorial. It really help me. However, I am a bit confuse .mdf...

Scott 1/18/2015 2:22 PM
In response to Migrating Classic ASP To ASP.NET Razor Web Pages Part Two- Data Access
Just an FYI: I get an exception when clicking the link for Razor Syntax and Visual Basic. "A was...

F.Manicou 1/15/2015 8:54 PM
In response to Conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value
Thank you so much!!!!...

Satyabrata 1/13/2015 3:24 PM
In response to Entity Framework 6 Recipe - Grouping By Year And Month
Nice article. Learned a lot. Thanks for sharing....

Gjuro 1/13/2015 2:41 AM
In response to MVC 5 with EF 6 in Visual Basic - Creating an Entity Framework Data Model
under subtitle "Create a logging interface and class" remove excess empty lines at the start of the...