AbsolutePage in MySQL

Monie · #1 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.

Monie · #2 Feb 12th, 2008, 02:37

Yes, I am happily solving this thread

It all about the cursor type that causes all that error! What I do is to force ADO to construct a static cursor by specifying a client-side cursor!!!

My previous Database Connection (updated with the static cursor):

Code: Select all

Dim connString, rs, conn
connString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER="& DB_SERVER &"; DATABASE="& DB_NAME &"; OPTION=4; UID="& DB_USER &"; PASSWORD="& DB_PASS &";"
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
rs.cursorlocation = 3
conn.Open(connString)

And the If statement just works FINE

Code: Select all

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

    rs.AbsolutePage = CurrentPage
End If

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MySql help	nashultz07	Databases	4	Jul 27th, 2007 09:11
Mysql/php	marie2007	PHP Forum	7	Jul 10th, 2007 13:20
Mysql	Paul00000001	Databases	7	Sep 13th, 2006 21:48
ASP and MYSQL	QuikFrozen	Classic ASP	3	Aug 16th, 2006 17:58
help with php and mysql	robukni	Databases	30	Jan 30th, 2006 22:58

		Webforumz.com > Main Forums > Program Your Website > Databases
AbsolutePage in MySQL