[sqlalchemy] bad result when querying for null values (in pk at least)

2009-10-15 Thread alexbodn . groups
hello friends, thank you very much for making and contributing to this great project. i have a table with a multi-field primary key, one of which allows null. when querying this table, i don't get the records with null in that field, even if i'm specifically asking them in where. but what

[sqlalchemy] Re: bad result when querying for null values (in pk at least)

2009-10-15 Thread alexbodn . groups
thanks a lot mike, it's working great now. but this flag should be implied if one of the primary key fields is nullable (especially since it's not nullable by default). what would you think? On Thu, Oct 15, 2009 at 14:28, Mike Conley mconl...@gmail.com wrote: add allow_null_pks to your

[sqlalchemy] Re: bad result when querying for null values (in pk at least)

2009-10-15 Thread alexbodn . groups
On Thu, Oct 15, 2009 at 15:43, Mike Conley mconl...@gmail.com wrote: On Thu, Oct 15, 2009 at 9:21 AM, alexbodn.gro...@gmail.com wrote: thanks a lot mike, it's working great now. but this flag should be implied if one of the primary key fields is nullable (especially since it's not nullable

[sqlalchemy] Re: bad result when querying for null values (in pk at least)

2009-10-15 Thread alexbodn . groups
On Thu, Oct 15, 2009 at 15:48, King Simon-NFHD78 simon.k...@motorola.com wrote: -Original Message- From: sqlalchemy@googlegroups.com [mailto:sqlalch...@googlegroups.com] On Behalf Of Mike Conley Sent: 15 October 2009 14:43 To: sqlalchemy@googlegroups.com Cc: SQLElixir Subject: