Re: General question about NOT EXISTS...

2010-12-07 Thread Wayne Smith
> > How does that look when you are building an object list in the Q( )... > style format? Where I am hung up is finding syntax examples of how to > do the functional equivalent of a sql where not exists clause. > > Is there a way to do this without using .extra() and using just normal > django? >

Re: General question about NOT EXISTS...

2010-12-06 Thread andy
Sorry for the double post. The table should have been A = Blog, B = blogentry and C = entry On Dec 7, 1:12 am, andy wrote: > Well django has a ISNULL which I guess could be use to get the result > that you want. I'm a bit new to django and have not done any many-to- > many relationships as yeah b

Re: General question about NOT EXISTS...

2010-12-06 Thread andy
Well django has a ISNULL which I guess could be use to get the result that you want. I'm a bit new to django and have not done any many-to- many relationships as yeah but I'm guessing you could do something like this: Lest say table A = Blog, B = entry and C = blogentry Blog.objects.filter(entry_

Re: General question about NOT EXISTS...

2010-12-06 Thread andy
Well django has a ISNULL which I guess could be use to get the result that you want. I'm a bit new to django and have not done any many-to- many relationships as yeah but I'm guessing you could do something like this: Lest say table A = Blog, B = entry and C = blogentry Blog.objects.filter(entry_

General question about NOT EXISTS...

2010-12-06 Thread Wes Wagner
This is a generic question because I am a newbie and things are not gelling quite 100% on how to write Q statements to get a filter to do everything one wants. Let's say you have Table A and Table B and Table C, where Table B has a foreign key to table A and Table C (a manually constructed many to