>From >http://web2py.com/book/default/chapter/06#orderby,-groupby,-limitby,-distinct
I think the following may work: for row in db().select(db.table.ALL, limitby=(0, 7)): print row.record for row in db().select(db.table.ALL, limitby=(0, 3). orderby=~db.table.id): print row.record On Dec 18, 7:30 am, Rick <sababa.sab...@gmail.com> wrote: > Hi, > > In the database there are value records for 31 days. Now I'm trying to > make a html file where a value is presented for each day of a week. > The code below presents all the recorded values, and I don't know how > to make it printing the 7 first records only, or the last 3 records. > > Thanks in advance for help. > > <table> > <tr> > <td>Day| <br> Value| </td> > {{for record in records:}} > <td>{{=record.day}} <br> {{=record.value}}</td> > {{pass}} > </tr> > </table>