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