[sqlalchemy] Foreign key not updated

2007-01-03 Thread Arnar Birgisson
Hi folks, I'm having a problem, illustrated here: http://paste.turbogears.org/paste/756 This is with Python 2.4 and SA 0.3.3. What happens is that when I have two parent objects (Jobs in my case) and one child object (a Page) - and move the child between parents, the session.flush() does not

[sqlalchemy] Re: Using TurboGears/SQLAlchemy with SQL Server, via adodbapi

2007-01-03 Thread Paul Johnston
Hi Rick, Thanks for your enthusiastic responses. I have got cracking and created ticket #411 with a patch for the commit problem. See what you think of my approach; it could help simplify the adodbapi/pymssql differences. If you're happy with this I'll create a test case as well. I'm off to