Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > Recordset paging headache .....

Thread Tools

Recordset paging headache .....

Posts: n/a

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

__________________________________________________ ____________

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Recordset paging headache ..... David ASP General 5 04-24-2007 08:27 PM
ADO recordset paging Ing. Branislav Gerzo ASP General 3 06-24-2005 01:33 PM
recordset paging sara ASP General 3 04-13-2005 03:25 PM
RecordSet.Move or RecordSet.AbsolutePosition?? Hung Huynh ASP General 8 09-24-2003 11:07 AM
Recordset Paging between frames Dima ASP General 1 07-22-2003 06:16 PM