Recordset paging headache .....

Recordset paging headache .....

am 24.04.2007 11:48:57 von davidgordon

Hi,

I have an asp page which displays a list of records depending on what
was selected via another form.
I want to have this form broken down, displaying only 10 records, with
links underneath to display as
'Previous' and 'Next'

____________________________________________________________ _

Firstly I have an include file for the connection which is:

strConnection = "xxxxxxxxxx"
Set adoDataConn = Server.CreateObject("ADODB.Connection")
adoDataConn.Open strConnection

____________________________________________________________ __

On my actual asp page, I just run the following code and print the
results on the screen

strquery = "SELECT * FROM reports ORDER BY ReportID DESC;"
Set RS = adoDataConn.Execute(strquery)

if RS.EOF then



____________________________________________________________ __