Velocity Reviews - Computer Hardware Reviews

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

Reply
Thread Tools

Recordset paging headache .....

 
 
David
Guest
Posts: n/a
 
      04-24-2007
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



__________________________________________________ ____________

 
Reply With Quote
 
 
 
Reply

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



Advertisments