[sqlalchemy] Re: db autogenerated pks?

2007-09-11 Thread KyleJ
You probably need to override the autoloaded primary key column: http://www.sqlalchemy.org/docs/04/metadata.html#metadata_tables_reflecting_overriding Specify the type with MSUniqueIdentifier from sqlalchemy.databases.mssql On Sep 11, 9:01 am, Smoke <[EMAIL PROTECTED]> wrote: > Hi All, > > I'm n

[sqlalchemy] Re: Many-to-Many, Column not available

2007-09-11 Thread KyleJ
Oh, and yes I did try (without any change) specifying uselist=True for the BaseType mapper. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googleg

[sqlalchemy] Re: Many-to-Many, Column not available

2007-09-11 Thread KyleJ
Thanks for the replies; I think I'm going in the right direction now. Polymorphic association looks almost exactly like what I'm wanting to do but, for now I changed the requirements to something simpler that should just be an association object pattern. The weird thing is, I only ever get one

[sqlalchemy] Many-to-Many, Column not available

2007-09-11 Thread KyleJ
I get the same result with this in 0.3.10 and 0.4beta5 Basic idea: I have two tables which hold various data and a third table which let's different rows in each table be related to another (many-to-many relationship). Table/ORM code: base_table = Table('base_type', metadata, Column('id'