Re: order_by with foreign keys

On 9/10/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > that helps, thanks very much... > > i got a bit confused by all the tickets concerning this issue. also > the documentation doesn't mention any bugs, well bad luck ;) fortunately you can add a comment to the documentation, mentioning

Re: order_by with foreign keys

that helps, thanks very much... i got a bit confused by all the tickets concerning this issue. also the documentation doesn't mention any bugs, well bad luck ;) On 10 Sep., 17:53, Michael Radziej <[EMAIL PROTECTED]> wrote: > On Mon, Sep 10, [EMAIL PROTECTED] wrote: > > > hi guys, > > i noticed

Re: order_by with foreign keys

On Mon, Sep 10, [EMAIL PROTECTED] wrote: > > hi guys, > i noticed there have been questions about this before, but none of > those threads was helpful. > > i've got a simple db-request, the result should be ordered by a column > "thema" in a foreign key table "Thema": >

order_by with foreign keys

hi guys, i noticed there have been questions about this before, but none of those threads was helpful. i've got a simple db-request, the result should be ordered by a column "thema" in a foreign key table "Thema": Test.objects.select_related().order_by("my_app_thema.thema"): this produces the

Re: order_by with Foreign Keys

Hmm... the site hangs forever in Apache 2.x when I try this...I've emailed the branch developer to ask if there is a known issue w/ select_related... hopefully I can get it worked out ;) --~--~-~--~~~---~--~~ You received this message because you are subscribed

Re: order_by with Foreign Keys

I found this patch which fixes it. I've been using it for a while now: http://code.djangoproject.com/ticket/2210 Honza Král wrote: > this works fine, but if you forget the select_related() it will result > in a cross join which is probably the last thing you want from your > database... > > I

Re: order_by with Foreign Keys

this works fine, but if you forget the select_related() it will result in a cross join which is probably the last thing you want from your database... I was bitten by this when I specified this sort of ordering in the model... On 1/13/07, gordyt <[EMAIL PROTECTED]> wrote: > > Hi Carole, > >

Re: order_by with Foreign Keys

Hi Carole, There is a workaround for this problem. I am using the latest subversion build of django, so I don't know if it works with the last official build or not. Here is an example: ProductVersion.objects.select_related().order_by("kindledb_product.name","version_number") Here are the

order_by with Foreign Keys

I've seen a few posts that this was a bug where you cannot specify order_by with a column from a foreign key ... order_by(foreignkeytable__foreignkeycolumn) because it says table not found. Does anyone know if there are plans to fix this...or if there is a work around? I have several resultsets