[sqlalchemy] Re: Issue using rev 2425

2007-03-18 Thread Michael Bayer
i have an idea where this issue is, since it will become a unit test you can save me some trouble by sending along some tables defs too. its that the columns in the primaryjoin are not explicitly part of the mapped tables and i have to add a conditional somewhere. On Mar 18, 2007, at 7:56

[sqlalchemy] Re: Doing a many-to-many join but accessing the contents of that join table

2007-03-18 Thread Michael Bayer
dont use secondary, use an association object which makes your m2m table a fully mapped table of its own. its described in the docs. On Mar 18, 2007, at 3:42 AM, tml wrote: Hello! I have this code in my model: user_group_table = Table('user_group', metadata, Column('user_id',

[sqlalchemy] Re: pyodbc and tables with triggers

2007-03-18 Thread Rick Morrison
Tim, I committed a patch from ticket #480 today from that adds some improved module-switching code to the MSSQL interface. See how that works for you. On 3/16/07, Tim Golden [EMAIL PROTECTED] wrote: Rick Morrison wrote: Sorry, Stephen, I replied too early; your second email arrived

[sqlalchemy] Re: pyodbc and tables with triggers

2007-03-18 Thread Tim Golden
Rick Morrison wrote: Tim, I committed a patch from ticket #480 today from that adds some improved module-switching code to the MSSQL interface. See how that works for you. I'll have a look when I get near an MSSQL-connected machine (tomorrow earliest). Thanks v. much. TJG

[sqlalchemy] Re: Issue using rev 2425

2007-03-18 Thread Michael Bayer
nevermind, im pretty sure ive identified the condition youre having and added a check/fix/unittest in rev 2428. if rev 2428 still doesnt work, then please forward along a full test case. On Mar 18, 2007, at 7:56 AM, Steve Zatz wrote: I hadn't updated in several weeks so I am not sure

[sqlalchemy] Re: Conflicting columns with secondaryjoin

2007-03-18 Thread Michael Bayer
hey there - i just found another issue which may be the problem youre having on this. if you try rev 2428 i think that might fix your issue (but also, your tags relationship below might also need to be declared viewonly=True since im not sure if it can be flushed). On Mar 16, 2007, at