Re: Nested in statements

2007-10-16 Thread Thomas Guettler
Am Dienstag, 16. Oktober 2007 15:48 schrieb Jeremy Dunck: > On 10/16/07, Thomas Guettler <[EMAIL PROTECTED]> wrote: > > Hi, > > > > you can use the extra() method of QuerySet: > > > > Example: Entry.objects.extra(where=['id IN (3, 4, 5, 20)']) > > How is this different from __in, and where did

Re: ***SPAM*** Nested in statements

2007-10-16 Thread Jeremy Dunck
On 10/16/07, Thomas Guettler <[EMAIL PROTECTED]> wrote: > > Hi, > > you can use the extra() method of QuerySet: > > Example: Entry.objects.extra(where=['id IN (3, 4, 5, 20)']) > How is this different from __in, and where did that list of numbers come from? :)

Re: ***SPAM*** Nested in statements

2007-10-16 Thread Thomas Guettler
Hi, you can use the extra() method of QuerySet: Example: Entry.objects.extra(where=['id IN (3, 4, 5, 20)']) http://www.djangoproject.com/documentation/db-api/#extra-select-none-where-none-params-none-tables-none Am Dienstag, 16. Oktober 2007 14:29 schrieb Rufman: > in SQL terms this is what

Re: Nested in statements

2007-10-16 Thread Jeremy Dunck
On 10/16/07, Rufman <[EMAIL PROTECTED]> wrote: > > in SQL terms this is what i want to do: > SELECT * > FROM `build` > WHERE `iKeyBuildNr` > IN ( > >SELECT `iFKeyBuildNr` >FROM `package` >WHERE `strPackageName` > IN ("denon_AVR4306") >) > > How can i do

Re: Nested in statements

2007-10-16 Thread Rufman
in SQL terms this is what i want to do: SELECT * FROM `build` WHERE `iKeyBuildNr` IN ( SELECT `iFKeyBuildNr` FROM `package` WHERE `strPackageName` IN ("denon_AVR4306") ) How can i do this with the django db api? I tried it with __in, but it doesn't seem to

Re: Nested in statements

2007-10-16 Thread Rufman
: in SQL terms this is what i want to do: SELECT * FROM `build` WHERE `iKeyBuildNr` IN ( SELECT `iFKeyBuildNr` FROM `package` WHERE `strPackageName` IN ("denon_AVR4306") ) How can i do this with the Django db API? I tried it with __in, but it doen't seem to take

Re: Nested in statements

2007-10-16 Thread Rufman
in SQL terms this is what i want to do: SELECT * FROM `build` WHERE `iKeyBuildNr` > IN ( > > SELECT `iFKeyBuildNr` > FROM `package` > WHERE `strPackageName` > IN ( > & quot; > > denon_AVR4306 & quot; > > ) > ) --~--~-~--~~~---~--~~ You received this message

Nested in statements

2007-10-16 Thread Rufman
in SQL terms this is what i want to do: SELECT * FROM `build` WHERE `iKeyBuildNr` IN ( SELECT `iFKeyBuildNr` FROM `package` WHERE `strPackageName` IN ( & quot; denon_AVR4306 & quot; ) ) --~--~-~--~~~---~--~~ You received this message because you are subscribed