• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Another statement to worry about... MS Access related

 
Ryan Crow
Greenhorn
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!!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic