make record go over different pages

[Mo*1]

Im trying to build a website with asp.
ive got an extra long record that i would like to spread accross different
pages as i have limited space.
i want to show only a certain amount of text on each page which im using crop
sentence function.
but what im not sure about is how to continue the recordset on a new page from
where it stopped the last page
any one help?

[David Powers]

Mo*1 wrote:

> but what im not sure about is how to continue the recordset on a new page from
> where it stopped the last page

Insert > Application Objects > Recordset Paging.

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]

[Bren]

Hi Mo

Two ways that should work

1. Create several pages for the record and select the same record each time
but only show the recordset items you want to show on each page. i.e.
page1.asp > Display Recordset items 1, 2, 3, 4.
Then have a link that goes to page2.asp?recordidforfiltering=xxxx

page2.asp > Dispaly recordset items 5, 6, 7, 8. Add link to page3 etc etc.

2. Use one page and post back to that page each time but set up regions on
your page and only show the regions you want for each page view. i.e.
page1.asp?viewnumber=1

If Request("viewnumber") = 1 Then
Show region 1. with a link back to page1.asp something like
<a href="page1.asp?viewnumber=2">View More</a>
End If

If Request("viewnumber") = 2 Then
Show region 2. with a link back to page1.asp something like
<a href="page1.asp?viewnumber=3">View More</a>
End If

If Request("viewnumber") = 3 Then
Show region 3. with a link back to page1.asp something like
<a href="page1.asp?viewnumber=4">View More</a>
End If

And so on until you have finished displaying your record.
A Select Case statement would probably be faster than the IF statement, ut
thats down to preference I guess.
Hope this helps.

Regards
Bren

/*************************************
Why do I climb mountains? Because they are there.
[url]www.3peakschallenge.co.uk[/url]
*************************************/