what DB backend ? often you can just compare to "1" or "0".
On Jun 10, 2008, at 12:03 PM, Jonathan Vanasco wrote: > > this should be straightforward, I think... > > I'm trying to do > > "select email_address from user where is_verified is not true" > ( or "is not null" or "is not false" ) > > > This part is simple : > Session.execute( sqlalchemy.select( [ User.c.email ] ) ) > > This part is not: > > Session > .execute > ( sqlalchemy > .select( [ User.c.email ] , .User.c.is_verified.######### ) ) > > I can't figure that last bit out. There's nothing in > ColumnOperators , and the "is not" , "is" stuff seems to be tucked > away in literals. > > can anyone give me a suggestion? > > thanks! > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
