Calculate page of record

lachdanan · March 11th, 2005, 10:04 AM

Hi!

I am working on a small app that displays information stored in a database (Access), 20 items per page.

My problem is that I would like is if I link to a specific record (for example "default.asp?ticket=25") I want the app to calculate the page of the record and redirect to "default.asp?page=2&ticket=25".

Anyone got ideas?
Thanks!

(Here are the columns of the table):

Code:

TICKET_ID
TICKET_MSG
CLIENT_ID

MaBel · April 22nd, 2005, 08:25 AM

What will count how many page you have?
I guess you could do a loop and have counter inside your loop.
<%
if countingquery.Bof and countingquery.Eof) then
else

Counter=1
Do while not countingquery.eof

count=counter+1 'this count how many time you retrieve your information.
countingquery.Movenext
Loop
end if
response.redirect "default.asp?page="&Counter&"&ticket=25
%>