ordering. missing FROM-clause entry for table "locations_location"

2007-12-06 Thread sector119
Hi! I use current trunk and I can't order by location field. When I try, I'he get an error: missing FROM-clause entry for table "locations_location" LINE 1: ... FROM "organizations_organizationoffice" ORDER BY "locations... ^ Exception Location: /home/sector119/devel/django_src/django/db/ bac

Re: ordering. missing FROM-clause entry for table "locations_location"

2007-12-06 Thread Empty
Read this: http://www.mail-archive.com/django-users@googlegroups.com/msg37967.html and this: http://www.djangoproject.com/documentation/db-api/#order-by-fields Michael Trier blog.michaeltrier.com On Dec 6, 2007 10:21 AM, sector119 <[EMAIL PROTECTED]> wrote: > > Hi! > > I use current trunk and

Re: ordering. missing FROM-clause entry for table "locations_location"

2007-12-06 Thread Kenneth Gonsalves
On 06-Dec-07, at 9:04 PM, Empty wrote: > http://www.mail-archive.com/django-users@googlegroups.com/ > msg37967.html > > and this: > > http://www.djangoproject.com/documentation/db-api/#order-by-fields read it, implemented it - still get the same error -- regards kg http://lawgon.livejournal

Re: ordering. missing FROM-clause entry for table "locations_location"

2007-12-06 Thread Rajesh Dhawan
Hi, > "locations_location" is really missing in FROM-clause entry... why? Drop in to "manage.py shell", and try a query set with the ordering "locations_location.id". Does that work? If not, add a select_related() to your query set. Does that work? If not, verify that the Location table is in an

Re: ordering. missing FROM-clause entry for table "locations_location"

2007-12-06 Thread Malcolm Tredinnick
On Thu, 2007-12-06 at 21:21 +0530, Kenneth Gonsalves wrote: > > On 06-Dec-07, at 9:04 PM, Empty wrote: > > > http://www.mail-archive.com/django-users@googlegroups.com/ > > msg37967.html > > > > and this: > > > > http://www.djangoproject.com/documentation/db-api/#order-by-fields > > read it, i

Re: ordering. missing FROM-clause entry for table "locations_location"

2007-12-07 Thread sector119
When I try to use admin in queryset-refactor branch I get errors with handle_legacy_orderlist. It was removed from django.db.models.query, but still use in django/ contrib/admin/views/main.py at ChangeList.get_ordering.. On 7 Грд, 01:21, Malcolm Tredinnick <[EMAIL PROTECTED]> wrote: > On Thu, 200

Re: ordering. missing FROM-clause entry for table "locations_location"

2007-12-07 Thread sector119
more errors.. when I try to retrive some data: % python2.5 manage.py shell >>> from organizations.models import Organization >>> offices = list(Organization.objects.all()) File "/home/sector119/devel/django_src/django/db/models/sql/ query.py", line 524, in find_ordering_name order)) File

Re: ordering. missing FROM-clause entry for table "locations_location"

2007-12-07 Thread Malcolm Tredinnick
On Fri, 2007-12-07 at 06:53 -0800, sector119 wrote: > When I try to use admin in queryset-refactor branch I get errors with > handle_legacy_orderlist. > It was removed from django.db.models.query, but still use in django/ > contrib/admin/views/main.py at ChangeList.get_ordering.. Since the query