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.
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!!
subject: Another statement to worry about... MS Access related