Solved: Table not found error when ordering by foreign key

My original question (http://groups.google.com/group/django-users/browse_frm/thread/1581881fb9c1ddc1/#): Here is a simplified version of what I am trying to do: App X: class A: shortname = meta.CharField(maxlength=6) App Y: class B: the_A = meta.ForeignKey(A) Y.views: blist = bs.get_li

Re: Table not found error when ordering by foreign key

Hi Adrian, Thanks for the reply. I did try using the full table names without success. This is the error and traceback (with real class names): OperationalError at /debtors/current/ (1109, "Unknown table 'matterlist_matters' in order clause") Traceback (most recent call last): File "/opt/lo

Re: Table not found error when ordering by foreign key

On 3/13/06, jtm <[EMAIL PROTECTED]> wrote: > Y.views: > blist = bs.get_list(order_by=['as.shortname']) > > But Django is telling me that there is no table named 'as'. > Everything seems to be importing fine. Does anyone have any > hints? Go into your database command-line client and type "\dt" (P

Table not found error when ordering by foreign key

Here is a simplified version of what I am trying to do: App X: class A: shortname = meta.CharField(maxlength=6) App Y: class B: the_A = meta.ForeignKey(A) Y.views: blist = bs.get_list(order_by=['as.shortname']) But Django is telling me that there is no table named 'as'. Everything seem