I have a model that looks roughly like this...
class Client(models.Model):
name = models.CharField(maxlength=200, default='')
class Competitor(models.Model):
client = models.ForeignKey(Client)
site = models.ForeignKey(Site)
class Site(models.Model):
client = models.ForeignKey(Client)
pagerank = models.IntegerField(default=0)
...and if I do this... (or any ("site_site.pagerank",
"sites__site.pagerank" etc. ) variation of the order by clause)...
Client(name="Fred")
client = Client.objects.all()[0]
competitors = Competitor.objects.filter(client=client).select_related
().order_by("sites_site.pagerank")
... I get this...
> File "/Library/Frameworks/Python.framework/Versions/2.4/lib/
> python2.4/site-packages/MySQLdb/connections.py", line 35, in
> defaulterrorhandler
> raise errorclass, errorvalue
> OperationalError: (1054, "Unknown column 'site.pagerank' in 'order
> clause'")
I have never got related queries to work... ever... any advice?
thanks
tom
p.s But please no "it works for me"s :-)
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
