hi all,
im doing a resultset paging thing... so what i need now is having the statement to return 20 result on each query out of, say, 50000 rows...
so, with mysql, i should use the LIMIT x,y statement, right?
problem is, im deploying ms access... and the condition is much more complicated...
i need to :
1. select UserID, LogTime, BrowserType
2. from table User_Log
3. where UserID = '"+request.getParameter("UserID")+"'"
4. and with only 20 following results starting row X
5. order by LogTime DSC
now how do i make sense in a MS ACCESS compliable SQL statement?? and what is the placing sequence of order by, the limit clause, and the where statement...
many thanks for the info!!