On Aug 2, 2007, at 5:07 AM, che wrote:
> > Hi, > > On 31 Юли, 02:33, Paul Johnston <[EMAIL PROTECTED]> wrote: > >> Yes, please do. I think you'll find some tweak to MssqlCompiler can >> achieve this. >> >> BTW, AND/OR are not broken generally; I think it's just BIT >> columns they >> have a problem with. >> >> Paul > > I dont know how to restrict my changes only to where clause as mssql > has bit weird behavior - > in select like this it is ok: > select * from manager where not ( tobeornot = 1) > if the boolean expression is in the select part - sorry - error: > select not ( tobeornot = 1) from manager BUMMM > anyway the patch seems to work (at least for me). > > below is the patch if it can be useful for someone (also not sure that > this is the proper way) you might want to try a. working with the 0.4 trunk, which has a simpler compilation scheme and b. just overriding visit_select() to pass a flag down into sub-visit_XXX calls. also what specifically do you want to convert "select not (tobeornot=1) from manager" to be ? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
