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
