[Phplib-users] DB_Sql question

[Kelby Z. <ke...@sa...>]

Folks:

Gotta question for you. I am experiencing a unexpected problem when  
using the DB_Sql class. It appears that if I create a DB_Sql object  
to one database (and perform a query) then create a second DB_Sql  
object to another database (and perform a query), when I return to  
the first object, it's connection state is invalid. Due to the  
architecture of our app, I can not consolidate the two objects into  
one (that would be reused).

I have attached a sample as an example to show the problem.

Assume for the example there are:
--> two databases, DB1 and DB2
--> a table in each db (DB1.FILE and DB2.USER)

I have attached two SQL files for the tables along with the example.  
Any insight into why I am seeing this would be greatly appreciated.

Thanks.

KZ