paging a recordset via active connection & stored

Results 1 to 2 of 2

Thread: paging a recordset via active connection & stored

  1. #1
    Join Date
    Dec 1969

    Default paging a recordset via active connection & stored

    hi<BR><BR>i want to page a recordset&#039;s contents 5 records perpage. I have the paging script in place but i am having problems defining the appropriate parameters for my connection.<BR><BR>I am using an active connection (defined in an include file used by all other pages on my site). i am using the following method in each page that connects to the database (including the page i am refering to in this posting):<BR><BR>&#039;*************************** ****************<BR>dim rsGetArticleHeadings dbCommand.CommandText="GetArticleHeadings"<BR>set rsGetArticleHeadings=dbCommand.Execute<BR>&#039;** ******************************************<BR><BR> this is the recordset i want to page, can someone please tell me if i can set the appropriate connection parameters for this connection that will alow me to page the recordset and if so, how to do this<BR><BR>thanks<BR><BR>gelboe

  2. #2
    Join Date
    Dec 1969

    Default paging is an FAQ

    first, check the method there and then modify your code as required. you need to explicitly create a recordset, rather than implicitly as you&#039;re doing here.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts