cursortype error

[manicleek]

I have a pagination script and the first page appears fine, however if I click next I get a

ADODB.Recordset error '800a0cb3'

Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype

I have been told using "cn,3,3" with my sql will sort this but when I put in

NewsQuery = "SELECT * FROM Rogue.dataqfol ORDER BY Company DESC LIMIT 0, 10",cn,3,3
Set FiftyBest = objConn.execute(NewsQuery)

I get

Expected end of statement

test.asp, line 5

NewsQuery = "SELECT * FROM Rogue.dataqfol ORDER BY Company DESC LIMIT 0, 10",cn,3,3

 

[vbkris]

NewsQuery = "SELECT * FROM Rogue.dataqfol ORDER BY Company DESC LIMIT 0, 10",cn,3,3

is wrong,

u r setting a variable, there u cannot open a sql,
try this:
FiftyBest=server.createobject("ADODB.Recordset")
FiftyBest.open "SELECT * FROM Rogue.dataqfol ORDER BY Company DESC LIMIT 0, 10",cn,3,3

Known is handfull, Unknown is worldfull