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_knives.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
-~----------~----~----~----~------~----~------~--~---
