This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan 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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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!!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Another statement to worry about... MS Access related
 
Similar Threads
getting a range of returned rows?
MS Access getting on my nerves
OutOfMemoryError
Major Dilemna
JBoss-QL in 3.2.x Vs 3.0.x