what am I doing wrong?!

Im trying to limit my results to 4 and have a offset of 4 (which will change ie 8 on the next page....

my code is:

Set MyConn=Server.CreateObject("ADODB.Connection")
MyConn.Open "products_pbc"
Set Rs=MyConn.Execute("SELECT * From [products] Where Category='paperback'" ) LIMIT 4,4
WHILE NOT Rs.EOF

but I get the error:

Microsoft VBScript compilation error '800a0401'

Expected end of statement

paperbacks3.asp, line 59

Set Rs=MyConn.Execute("SELECT * From [products] Where Category='paperback'" ) LIMIT 4,4

and I cant find the problem at all!

Please help!

Dave

Ive changed it to

Set Rs=MyConn.Execute("SELECT * From [products] Where Category='paperback'LIMIT 4,4" )

to fix this problem, but now i get the error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Category='paperback' LIMIT 4,4'.

paperbacks3.asp, line 59

any ideas?

Cheers! Dave

You posted this question in mysql/postgres thread, yet the error message you are getting states you are using Access. Which is it? Access does not have a LIMIT statement. Instead google for the TOP statement, which works slightly differently.