Paged Search Results ?

[Alan Short]

Hi Guys

I've recently installed mySQL and am really enjoying using it...

I would like to write a simple db search page which will page the results when there are lots to return...

I'm using asp vbscript with mySQL however am having a few problems...


I've looked at several tutorials/code on the web and have tried using these with mySQL, however i'm getting an error :

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


I've set up a DSN for the db :

set adoConn = Server.CreateObject("ADODB.Connection")
set adoRS = Server.CreateObject("ADODB.Recordset")
adoConn.Open "DSN=mysql_dsn"
adoRS.ActiveConnection = adoConn


I'm guessing you can do a paged results set with mySQL.... Does anyone know how ??

Any help will be very much appreciated...

Cheers
A