• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Another statement to worry about... MS Access related

Ryan Crow
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!!
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic