Connection multiply databases and tables

Hi,

I have an external (company)database with 2 tables depart, and countries, wich i want to use in my rails-app.

Setup:

development (Local):   adapter: mysql   database: fly (tables > pages ect.)   username: root   password:   host: localhost

extern(company):   adapter: mysql   database: fly2 (tables > depart, countries)   username: root   password:   host: localhost

I created a depart model on my local sever

Class Depart < ActiveRecord ::Base set_table_name = "depart" establisch_connection :extern end

This works fine from my console; looks like this

Page.connection.instance_eval{@config:database]} "fly" Depart.connection.instance_eval{@config:database]} "fly2"

Because the tables depart, countries is on our central server i set the Pluralization off by the "set_table_name"

Now i want to connect also to the countries table with the same database-connection.

I have read that a creation of an external-class do the job

class External < ActiveRecord ::Base establisch_connection :extern end

class Depart < External end

class Countries < External end

Question: where i define my set_table_name for each class??

remco

Remco Zwaan wrote:

end

Question: where i define my set_table_name for each class??

remco

In the model.

hth

ilan