Oops, I had the ' ' in there somewhere in all my different iterations of trying to make this work .. so the query works, but I can't access the object in the template, or from the shell for that matter. Does something change by doing this type of query?
On the shell: >>> gear = Gear.objects.select_related().order_by('-generic_info__hits') >>> print gear Traceback (most recent call last): File "<console>", line 1, in ? File "/usr/lib/python2.3/site-packages/django/db/models/query.py", line 108, in __repr__ return repr(self._get_data()) File "/usr/lib/python2.3/site-packages/django/db/models/query.py", line 483, in _get_data self._result_cache = list(self.iterator()) File "/usr/lib/python2.3/site-packages/django/db/models/query.py", line 189, in iterator cursor.execute("SELECT " + (self._distinct and "DISTINCT " or "") + ",".join(select) + sql, params) File "/usr/lib/python2.3/site-packages/django/db/backends/util.py", line 18, in execute return self.cursor.execute(sql, params) File "/usr/lib/python2.3/site-packages/MySQLdb/cursors.py", line 163, in execute self.errorhandler(self, exc, value) File "/usr/lib/python2.3/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler raise errorclass, errorvalue OperationalError: (1054, "Unknown column 'itemengine_gear.generic_info__hits' in 'order clause'") ???? The template chokes the same way trying to access the object... I shouldn't have to change my code? rob On May 29, 4:16 pm, "Richard Dahl" <[EMAIL PROTECTED]> wrote: > http://www.djangoproject.com/documentation/db-api/ > contains the info you want. Try this: > Gear.objects.select_related().order_by('generic_info__hits') > > you could also set the order_by in the Meta of Item to hits and then you > could just do: > Gear.objects.select_related().order_by('generic_info') > > hth, > -richard > > On 5/29/08, robstar <[EMAIL PROTECTED]> wrote: > > > > > Hey guys, > > > I read through some of the threads here, but still can't get this > > simple scenario to work.. > > > DB name: gcdb > > > class Item(models.Model): > > hits = models.IntegerField(default=0) > > > class Gear(models.Model): > > generic_info = models.OneToOneField(Item) > > > Should this work?? > > > results = Gear.objects.select_related().order_by(generic_info__hits) > > > I also tried putting the db name in there like I saw in some old > > examples: > > > results = > > Gear.objects.select_related().order_by(gcdb_generic_info__hits) > > > Both result in the field not being found.. Any ideas??? thanks! > > > rob --~--~---------~--~----~------------~-------~--~----~ 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?hl=en -~----------~----~----~----~------~----~------~--~---