wood burning stoves 2.0*
The moose likes JDBC and the fly likes Another statement to worry about... MS Access related Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Another statement to worry about... MS Access related" Watch "Another statement to worry about... MS Access related" New topic
Author

Another statement to worry about... MS Access related

Ryan Crow
Greenhorn

Joined: Aug 19, 2002
Posts: 18
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.
 
subject: Another statement to worry about... MS Access related