This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
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!!
 
GeeCON Prague 2014
 
subject: Another statement to worry about... MS Access related