Re: Three table Lookup Question

Yes, that does it. Thank you. On Sun, Feb 1, 2009 at 8:06 AM, Karen Tracey wrote: > On Sun, Feb 1, 2009 at 4:36 AM, Kyle wrote: > >> Hello again. >> >> I have one more question about the three table lookup I am trying to >> complete. >> >> The details

Re: Three table Lookup Question

On Sun, Feb 1, 2009 at 4:36 AM, Kyle wrote: > Hello again. > > I have one more question about the three table lookup I am trying to > complete. > > The details of my situation are posted here: http://dpaste.com/115244/ > > Does anybody have any idea on how to use django's

Re: Three table Lookup Question

Hello again. I have one more question about the three table lookup I am trying to complete. The details of my situation are posted here: http://dpaste.com/115244/ Does anybody have any idea on how to use django's ORM to perform two INNER JOINS, a WHERE, and an ORDER BY? Thanks in advance for

Re: Three table Lookup Question

Yes, almost. It got me to understand the correct syntax. I noticed that my results were coming according to Industry's primary key, rather than the Industry integer field, so I appended another __industry Here is the solution: Project.objects.filter(campaign__industry__industry=x) Thank you

Re: Three table Lookup Question

I'm not sure I understand what you're asking, but projs = Project.objects.filter(campaign__industry=x) where x is one of 1-6 should do what you want, I think. Is that what you were asking? On Thu, Jan 29, 2009 at 9:54 AM, Kyle wrote: > > Hello! > > I am trying to get a

Three table Lookup Question

Hello! I am trying to get a list of "Projects" based on certain "Industry". (My naming convention, not django's) My models look like this: http://dpaste.com/114308/ "Project" has a foreign key to "Campaign". "Industry" also has a foreign key to "Campaign". Does it matter if both