Wouldn't last = db().select(db.table.ALL, orderby=~db.table.id, limit= (1,))[0] be better? Since this way only one row is being retrieved and less overhead?
On Mar 29, 5:26 pm, mdipierro <[email protected]> wrote: > last = db().select(db.table.ALL).as_list()[-1] > > On Mar 29, 3:42 pm, Michael <[email protected]> wrote: > > > I wasn't sure if when you do > > > query = db().select(db.table.ALL) > > > returns as an array of items? > > > I am trying to get the last item added into the TABLE. I thought i > > could do: > > > query = db().select(db.table.ALL) > > last = query[-1] > > return dict(last=last) > > > but I am getting the following error: > > > Traceback (most recent call last): > > File "gluon/restricted.py", line 98, in restricted > > File "/Users/michaelnovia/Documents/web2py/web2py.app/Contents/ > > Resources/applications/philosaraptor/controllers/default.py", line 24, > > in <module> > > File "gluon/globals.py", line 75, in <lambda> > > File "/Users/michaelnovia/Documents/web2py/web2py.app/Contents/ > > Resources/applications/philosaraptor/controllers/default.py", line 9, > > in quote > > File "gluon/sql.py", line 2036, in __getitem__ > > SyntaxError: SQLRows: no such row --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
