Re: Yet another __ne not equal discussion

2011-10-27 Thread Adam Moore
Opps! ... >     ).extra(where=['`data_school`.`site_name` != RAE'] should be ).extra(where=['`data_school`.`site_name` != %s'], params=['RAE'] which is case-in-point for why helping me avoid extra() is a good thing! ~Adam sM -- You received this message because you are subscribed to the

Re: Yet another __ne not equal discussion

2011-10-27 Thread Adam Moore
On Oct 27, 6:26 am, Kääriäinen Anssi <anssi.kaariai...@thl.fi> wrote: > > Adam Moore wrote: > > It's also worth noting that Q() objects permit the unary negation > > operator, but this also yields the undesired results of the exclude() > > call: > > Blog.obj

Yet another __ne not equal discussion

2011-10-27 Thread Adam Moore
Greetings! Thanks to everyone for Django! Long story short, I believe certain queries that are straightforward and easy in plain SQL are not directly achievable in Django at all. Obviously, Django is flexible enough that there is a workaround - but a workaround shouldn't be necessary in a