Le Mercredi 8 Mars 2006 14:26, Andy Shaw a écrit :
> PythonistL wrote:
> > Hi,
> > is there a way how to find out id of the first record in a table?
> > I will explain what I mean.
> > When I insert the first record into a table the id is 1.
> > when I insert next record, the id for this record will be 2.
> > But if I delete the first record, the id of the first record will be 2
> > .So, I need to find out the id of the first record.
> > Is it possible?
> > Thank you for help
> > L.
>
> As the ID field is auto-incremented, the earliest ('first') record will
> be the one with the lowest ID. In python, you can determine this by
> pulling all records from the database and finding the one with the
> lowest ID, or you can write a custom SQL query to do the same thing. I
> don't know if Django currently has a built-in feature to let you do
> this, though it is possible that the database will return the records in
> creation order anyway (someone correct me here).
>
> -Andy
>
You can also use django "build-in" method on your model objects like :
reqObs = something.get_list(order_by=('id',), limit=1)
if reqObs:
firstOb = reqObs[0]
Regards, Laurent.
--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users
-~----------~----~----~----~------~----~------~--~---
