I agree with Fionn, but I’ll go one step further and say that to me the Page is not a resource, it’s a property of the request. That makes me chose option 1 query string only. It just feels right. I really like how the Twitter API is structured restfully. Not too simple, not too … Read more
Finally, Microsoft SQL Server 2012 was released, I really like its simplicity for a pagination, you don’t have to use complex queries like answered here. For getting the next 10 rows just run this query: SELECT * FROM TableName ORDER BY id OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY; https://docs.microsoft.com/en-us/sql/t-sql/queries/select-order-by-clause-transact-sql#using-offset-and-fetch-to-limit-the-rows-returned Key points to consider … Read more
Use the .scroll() event on window, like this: $(window).scroll(function() { if($(window).scrollTop() + $(window).height() == $(document).height()) { alert(“bottom!”); } }); You can test it here, this takes the top scroll of the window, so how much it’s scrolled down, adds the height of the visible window and checks if that equals the height of the overall … Read more
You can use a subquery for this like select * from ( select * from emp order by sal desc ) where ROWNUM <= 5; Have also a look at the topic On ROWNUM and limiting results at Oracle/AskTom for more information. Update: To limit the result with both lower and upper bounds things get … Read more