Hi,
Has an external table wich i connect through this code. So the table "bestemming" is stored on the exterbal database fly2.
class External < ActiveRecord::Base establish_connection :extern self.abstract_class = true end
class Bestemming < External has_and_belongs_to_many :tags belongs_to :land, :foreign_key => "landcode" set_table_name "bestemmingen" set_primary_key "bestemming_id" end
On my rails app database fly1 i added to 2 tables for tagging.
CREATE TABLE `tags` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) NOT NULL default '', PRIMARY KEY (`id`) )
CREATE TABLE `expenses_tags` ( `bestemming_id` int(11) NOT NULL default '0', `tag_id` int(11) NOT NULL default '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1)the relating table is in alphabetical order bestemming_tags 2)the field relating to a tag’s id is tag_id 3)the field relating to an bestemming’s id is bestemming_id(database fly)
I added some tag-list code in my editing-form for bestemming. I got this error.
Mysql::Error: Table 'fly2.bestemmings_tags' doesn't exist: SHOW FIELDS FROM bestemmings_tags
I goes to the wrong database!!!!
Help wanted please