Re: [SQLObject] BUG: ForeignKey in another database

[J-P L. <sql...@si...>]

OK, I've narrowed this down.  It works fine when accessing the records 
directly using Notes(1).user.name.  However, when iterating over a query 
result, it fails.

for rec in Notes.select():
    print rec.user.name

I'm looking at the differences between the versions.  With the latest 
release, conn is being passed along whereas in the previous release it's 
retrieved from the instance.  I assume all this connection passing was 
added to resolve transaction problems.  Is there a way to make 
iterSelect work using 2 databases?


Ian Bicking wrote:

> Hmm... I'm not really sure.  It sounds like you haven't created the 
> table like you should have.  Though I also feel like "user" is a 
> reserved word, so it shouldn't even work anyway.  To test -- what 
> happens when you do __connection__.queryAll('SELECT * FROM user')?