Does latest()[0] work exactly as the original poster was looking for? latest() works based on a date field, not the pk field (which *could* return a result different than expected).
Tom's approach, explicitly ordering by pk, would work exactly as desired. On Feb 23, 6:08 am, Mike Ramirez <gufym...@gmail.com> wrote: > On Wednesday, February 23, 2011 05:04:29 am Tom Evans wrote: > > > > > > > > > > > On Wed, Feb 23, 2011 at 12:57 PM, Sithembewena Lloyd Dube > > > <zebr...@gmail.com> wrote: > > > Hi everyone, > > > > How would one fetch a single item with the largest id (or most recent > > > date of creation) via the database API? > > > > -- > > > Regards, > > > Sithembewena Lloyd Dube > > > Foo.objects.all().order_by('-pk')[0] ? > > > Cheers > > > Tom > > also latest()[0] > > Mike > > http://docs.djangoproject.com/en/1.2/ref/models/querysets/#django.db.... > -- > Bershere's Formula for Failure: > There are only two kinds of people who fail: those who > listen to nobody... and those who listen to everybody. -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.