>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 <[email protected]> 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>
