View Single Post

Monie · #1 (**permalink**) Feb 11th, 2008, 00:23

I have done my page paging which will display certain amount of data from my ACCESS database. Now I am migrating my database to MySQL and it seems that MySQL do not support AbsolutePage.

HTML: Select all

If Not rs.EOF Then
    rs.MoveFirst
    rs.PageSize = NumPerPage
    TotalPages = rs.PageCount

    'Set the absolute (current) page
    rs.AbsolutePage = CurrentPage
End If

This code works perfectly in ACCESS database

This is the error message that I get:

Quote:

Error Type:
ADODB.Recordset (0x800A0CB3)
Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype.