Another statement to worry about... MS Access related
posted 14 years ago
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...