Hi Tom, Are you wanting the same 100 results you got in the first query just ordered by title, or are you looking for a different 100 results based on the order by title?
If you are looking for a different list of a 100 results, which is how I'm taking your email, then you'd need to do another query where the results are ordered by the title. The only other way would be to return all the records in the first result instead of limiting it to 100 and then you could sort based on the columns and grab the first 100 records, but I would guess this method would would most likely be more expensive than doing two separate queries to the DB (specially if there are a lot of records). --James On 10/10/06, Tom Smith <[EMAIL PROTECTED]> wrote: > > Sorry for what is probably a simple python question, but if I have a > list of Products and I have searched for 100 of them ordered by x... > > then how do I then sort the QuerySet returned by title? > > I can't do an .. object_list = products.items().sort('title') > > because I have already done a [:100] on the results... > > thanks > > tom > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---