Showing Pages in the search result.

Results 1 to 2 of 2

Thread: Showing Pages in the search result.

  1. #1
    Join Date
    Dec 1969
    Posts
    34

    Default Showing Pages in the search result.

    I am using ASP and Access (at this time but I will have SQL server 7 when we go in production.)<BR><BR>I want to write a logic where I can show 10 rows from the table on one page and show something like [Next 10]. On next page get [Previous 10] ... etc.<BR><BR>Problem is I could not get the RecordCount and MovePrevious methods of the ADO resultset to work. Is there any work around for RecordCount and MovePrevious. Any suggestion on how to achieve this without compromising efficiency?<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969
    Posts
    7

    Default RE: Showing Pages in the search result.

    u must have a query which have inner join or any knd of join, while opening the record set u must suplly the lock na other details, just put 1,3,1 or 3,3,1 in last 3 parameters of the open statement,<BR><BR>now put movelast and movefirst statement after opening the page now use recordcount property. this should work perfactly ok<BR><BR>i hope u must know the logic of the page break, if not get back to me..<BR><BR>bye<BR><BR>

Posting Permissions

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