See my post about inheritance with the testprogram reproducing the problem.
Quoting Michael Bayer <[EMAIL PROTECTED]>: > er, this is why I was afraid to check in those shortened column > labels.....the "CONTENT_69C6" should be a column label that should > have been declared in the column clause of the SELECT. are you using > a hand-written column clause ? for now, you need to specify the > "labels" on the columns, usually easiest by just using the columns > themselves, i.e.: > > s = select([mytable.c.mycol1, mtable.c.mycol2, mytable2, ....] > > let me know if youre doing hand-written SQL, in which case i may need > to add an additional argument "label" to the Column object, which > indicates the "label" that should be used in selects (why do we use > labels ? to allow multi-table selects/selects with the same table > aliased to not have any conflicts, and also to appease databases like > SQLite that wont let you select from a subquery unless the subquery > defines labels for each column) > > On Mar 8, 2006, at 5:32 AM, Florian Boesch wrote: > > > Hi, > > > > I just switched from handwoven code for a m:n associations to the > > default > > property relation. Before that my code on the existing database was > > working. > > Now suddenly I get: > > SQLError: (DatabaseError) ORA-00904: "CONTENT_69C6"."ID": invalid > > identifier. > > > > Can somebody point me at some documentation for that feature or > > perhaps tell me > > what I additionally have to do in order to get it working? > > > > Thanks, > > Florian > > > > > > ------------------------------------------------------- > > This SF.Net email is sponsored by xPML, a groundbreaking scripting > > language > > that extends applications into web and mobile media. Attend the > > live webcast > > and join the prime developer group breaking into this new coding > > territory! > > http://sel.as-us.falkag.net/sel? > > cmd=lnk&kid=110944&bid=241720&dat=121642 > > _______________________________________________ > > Sqlalchemy-users mailing list > > Sqlalchemy-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users > > ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
