Hey Jonathan, What is the SQL that those lines create? I've used the == False syntax myself a few times. What does your actual SA query look like in code?
The best debugging trick I can offer for SA is to always run with all the debugging output on. This lets you see what SA thinks you're asking it to do, when it commits, what parameters it's passing around, and all the other goodness. Especially when posting questions to the list, including at least the relevant snippets will dramatically increase the quality of the responses :) Cheers! -G On Thursday, April 27, 2006, 2:37:04 AM, you wrote: > i'm trying to use the select syntax at building queries > http://sqlalchemy.org/docs/ > sqlconstruction.myt#constructing_select_whereclause > I can't seem to place a boolean field into the select statement > Based on the docs, I've tried : > VerificationHash.c.is_active == False, > VerificationHash.c.is_active == 'False', > not_(VerificationHash.c.is_active) > Does anyone have a clue? I'm using postgres 8 > ------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > Sqlalchemy-users mailing list > Sqlalchemy-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
