[sqlalchemy] Re: Can't determine join between 'engines' and 'versions'. Please specify the 'onclause' of this join explicitly ?

2009-05-23 Thread sniipe
to that table twice on both the min_version and max_version.  write (and test) the query you want in SQL first to get an idea for what you're doing. sniipe wrote: After change (delete 'version' attribute): ProgrammingError: (ProgrammingError) (1064, You have an error in your SQL syntax

[sqlalchemy] Can't determine join between 'engines' and 'versions'. Please specify the 'onclause' of this join explicitly ?

2009-05-22 Thread sniipe
Hi :) I have three tables: 1) t_version = sa.Table(versions, meta.metadata, sa.Column(id, sa.types.Integer(), primary_key=True, autoincrement=True), sa.Column(version, mysql.MSChar(length=100, collation='utf8_polish_ci'), nullable=False, unique=True) ) class Version(object): pass

[sqlalchemy] Re: Can't determine join between 'engines' and 'versions'. Please specify the 'onclause' of this join explicitly ?

2009-05-22 Thread sniipe
'InstrumentedAttribute' object nor 'Comparator' object has an attribute 'version' What am I doing wrong? On 22 Maj, 17:59, Michael Bayer mike...@zzzcomputing.com wrote: sniipe wrote: Hi :) I have three tables: 1) t_version = sa.Table(versions, meta.metadata,     sa.Column(id, sa.types.Integer