page spanning

bono20 · #1 (**permalink**) Aug 25th, 2004, 10:44

I wonder if anyone could help me on this one. At the moment when data is displayed from the database it is listed all on one page, extending down as far as its needs to. What I would like to do is limit it to a set number of records and span it over a number of pages which can be selected.

Does anyone know how to do this easily?

Cheers

John

Smokie · #2 (**permalink**) Aug 25th, 2004, 11:12

sure thing dude, its called "paging", there are millions of examples out there, heres an easy one:

Code: Select all

<%
set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DSN=AdvWorks"

set rs = Server.CreateObject("ADODB.Recordset")
rs.CursorLocation = 3  ' adUseClient
rs.Open "Select * from Employees", conn
rs.PageSize = 2
intPageCount = rs.PageCount

Select Case Request("Action")
	case "<<"
		intpage = 1
	case "<"
		intpage = Request("intpage")-1
		if intpage < 1 then intpage = 1
	case ">"
		intpage = Request("intpage")+1
		if intpage > intPageCount then intpage = IntPageCount
	Case ">>"
		intpage = intPageCount
	case else
		intpage = 1
end select
%>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<TITLE>ASP & ADO Paging</TITLE>
</HEAD>
<BODY bgColor=White text=Black>

<%
rs.AbsolutePage = intPage 
For intRecord = 1 To rs.PageSize 
	Response.Write "Record	number: " & intRecord & " " 
	Response.Write rs.Fields("FirstName") & " " 
	Response.Write rs.Fields("LastName") & "
" 
	rs.MoveNext
If rs.EOF Then Exit For 

Next

rs.Close
set rs = Nothing
conn.Close
set conn = nothing
%>
<form name="MovePage" action="default.asp" method="post">
<input type="hidden" name="intpage" value="<%=intpage%>">
<input type="submit" name="action" value="<<">
<input type="submit" name="action" value="<">
<input type="submit" name="action" value=">">
<input type="submit" name="action" value=">>">
Page: <%=Intpage & " of " & intpagecount%>
</form>
</BODY>
</HTML>

bono20 · #3 (**permalink**) Aug 26th, 2004, 10:40

Nice one mate, thats really cool. Cheers!

John

D3mon · #4 (**permalink**) Aug 26th, 2004, 19:21

or use Recordset.getRows to pull all the records into an array and Loop thru only the ones you want to display.

benbacardi · #5 (**permalink**) Sep 3rd, 2004, 08:18

where in the code above smokie, do you determine how many records are shown on each page? maybe im just being dumb but....

??:

Nick · #6 (**permalink**) Sep 3rd, 2004, 10:49

<blockquote id="quote" class="ffs">quote:<hr height="1" noshade="noshade" id="quote" />Originally posted by benbacardi
where in the code above smokie, do you determine how many records are shown on each page? maybe im just being dumb but....

??:<hr height="1" noshade="noshade" id="quote" /></blockquote id="quote">

rs.PageSize = 2

oh and don't use Request("intpage") - use Request.Querystring("intpage"). Otherwise expect random errors!!111!

/:P

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Best way to prevent access to page B except via page A?	Donny Bahama	PHP Forum	1	Apr 3rd, 2008 02:15
Green bar of colour at bottom of page gets bigger the more page is extended	pixelgirl	Web Page Design	1	Apr 1st, 2008 01:27
internal navigation, Linking from one page to a specific div in another page.	Oak	Web Page Design	5	Feb 8th, 2008 22:54
Linking an outside page back to previous framed page	MJustison	Starting Out	1	Oct 18th, 2007 17:49
A gap appears beween the Page Title and the Body Content of the page.	sovereign6	Web Page Design	6	Dec 18th, 2006 19:14

		Webforumz.com > Main Forums > Program Your Website > Classic ASP
page spanning