Hi,
I have always wanted to get the following working, but have never yet
mastered it :-(
I have an asp page which displays a list of records depending on what
was selected via another form.
I want to have these results 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
Scream
Else
Print Results
End If
__________________________________________________ ____________
What do I need to do to get this paging working. I have looked at many
example, but keep running into problems with bookmarks and recordset
not supporting this and that.
I would really appreciate any help in geting this working.
Thanks in advance
David