Yes much better!
On Mar 29, 6:00 pm, TheDude <[email protected]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
