hello,
I read in this thread (http://groups.google.com/group/web2py/
browse_thread/thread/add0a8ff0a086111) that cross database joins are
supported.
I'm trying to get this working.
I define my tables like this:
db1 = SQLDB("sqlite://db1.db")
db2 = SQLDB("sqlite://db2.db")
db1.define_table('a',
SQLField('name', 'string'),
)
db2.define_table('b',
SQLField('a_id', 'integer', requires=IS_IN_DB(db1, 'a.id', '%
(name)s')),
SQLField('name', 'string'),
)
In the appadmin interface the tables are connected so I assume the
above is correct.
Unfortunately I haven't figured out the right syntax for cross
database joins.
If I try:
db2(db2.b.a_id == db1.a.id).select(db1.a.name, db2.b.name)
or:
db2().select(db1.a.name, db2.b.name, left=db2.b.on(db2.b.a_id ==
db1.a.id))
Then I get "OperationalError: no such table: db1"
What is the correct cross database join syntax?
thanks, Richard
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
