Welcome Guest, Not a member yet? Register   Sign In
Joining tables in two dbs
#4

[eluser]Eric Brown[/eluser]
Right. It is = false because both databases are on the same server, and the persistent connection stays open with number 1 when called alone when i then initiate number two.

So the problem I have is not connecting to two different databases serially, but connecting to them in one query where I am joining tables. I could hardcode the database names in the query, but that doesn't allow me to update the names easily should I move hosts.

Thanks.


Messages In This Thread
Joining tables in two dbs - by El Forum - 05-18-2010, 10:21 PM
Joining tables in two dbs - by El Forum - 05-18-2010, 10:36 PM
Joining tables in two dbs - by El Forum - 05-18-2010, 10:45 PM
Joining tables in two dbs - by El Forum - 05-18-2010, 10:46 PM
Joining tables in two dbs - by El Forum - 05-18-2010, 10:47 PM
Joining tables in two dbs - by El Forum - 05-18-2010, 10:50 PM
Joining tables in two dbs - by El Forum - 05-18-2010, 10:52 PM
Joining tables in two dbs - by El Forum - 05-18-2010, 10:58 PM
Joining tables in two dbs - by El Forum - 05-18-2010, 11:01 PM
Joining tables in two dbs - by El Forum - 05-19-2010, 08:27 AM



Theme © iAndrew 2016 - Forum software by © MyBB