Using two databases

[eluser]gcanizal[/eluser]
Hi,

I have a question related with database management. I have the database "A" as default database in the file "database.php": $active_group = "A"
In the same file I have defined database "B".
One of my controllers uses B database:

Code:

$query = "SELECT *...."
        $this->a = $this->load->database('A',TRUE);
        $result_set = $this->a->query($query);

And then it uses database "A":

Code:

$query = "SELECT *...."
        $result_set = $this->db->query($query);

But the second piece of code returns a "DATABASE ERROR".

So, I want to know if after the first piece of code the default data base has changed and, in this case, it is now "B".

Does someone use multiple databases? Which is the best way to manage them?

Thank you in advance.