Offset begins in the right place, but paging doesn't show the right information (in this case it shows "1-5 of 162" rather than "21-25 of 162"), and clicking on the arrows does not page:

http://test.dwagn.org/wagn/limit_and_offset

--John

Might want to change it so that 20 starts with 20 (rather than with 21). John Sechrest assumed the latter behavior.

  --John Abbe.....Fri Jun 05 21:54:13 -0700 2009

we're using the standard meaning of offset from SQL. We can adjust it in the interface if we like, but the query value should have the traditional coder meaning.

  --Ethan McCutchen.....Mon Jun 08 20:05:47 -0700 2009

Okay. So do we want to remove the paging interface when an offset is specified? Seems broken to leave it as is.

  --John Abbe.....Mon Jun 08 20:16:09 -0700 2009

no, let's fix it. paging interface is broken, numbering isn't.

  --Ethan McCutchen.....Sun Aug 02 21:16:17 -0700 2009

Group Pattern Language would like offset so that we can implement a "more news" page that doesn't include the news items from the front page.

  --John Abbe.....Wed Apr 14 14:36:51 -0700 2010

So, given that removing the paging interface is a separate issue, I think we're ready to close this, no?

  --Ethan McCutchen.....Tue May 11 13:51:55 -0700 2010

Yes.

Paging shows the correct information now anyway.

  --John Abbe.....Sun Feb 13 22:16:26 -0800 2011