Re: Joins with multiple databases and temporary tables

2011-03-30 Thread bish029
for different databases the query could be formatted as s=temp1.objects.using("mytemp").filter(refId=table1.objects.using("normal").get(pk=something).id) where temp1 is table in database mytemp.table1 in databse normal I cannot understand the get argument but may be if you give it a try with a

Joins with multiple databases and temporary tables

2011-03-30 Thread Gary Gendel
I've got a strange situation and I was wondering how to handle it. The database has stored procedures that crunch on tables and store the results in temporary tables. These resulting tables point to various records in persistent tables. The first question is how to control the connection in