similar to: Linking two tables using a lookup table

Displaying 20 results from an estimated 4000 matches similar to: "Linking two tables using a lookup table"

2006 Jun 16
4
duplicate entry issue in acts_as_taggable gem
Hi, I am using the ''acts_as_taggable'' gem and have issues when I try to ''tag'' an entity with a ''tagname'' already defined. i.e 1) book[1].tag(''science'',''paperback'') --> works fine 2) book[2].tag(''roman'',''physics'',''paperback'') --> creates an
2006 Jun 21
4
Simplest way to demonstrate a RoR app
Hi, I have built a simple RoR application and would like to show it to some friends. I would like to assign a dyndns URI like "myapp.dyndns.org" address to point to the application. As the WEBrick/Mongrel servers are running in "localhost (so loopback connections)" and I couldn''t bind them to the external server name or couldn''t bind them to my IP
2006 Jun 05
6
HTML Parsing libraries
Hi, What is the best way to parse HTML? Or is there a simple way to convert a table to an array? I tried beautiful_soup and the built-in htmltools, but have trouble getting them to run. Any pointers? Thanks, Hari -- Posted via http://www.ruby-forum.com/.
2006 Jun 05
5
adding habtm through migrations
Hello, I''m stuck, I''ve got a model Product and would like to add a new model called Category. Furthermore, I want to set up a many2many relationship between the mentioned models. the problem is that I do not know how to set the primary key in the categories_products table. this is what I''ve got in my migration file: create_table :categories do |t| t.column :name,
2006 Aug 04
3
Migration::alter statements ??
Hi, Where to put the execute statements in migration scripts? e.g, I would like to create a table and add a foreign_key reference. def self.up ?? execute "alter table ...." create_table :my_table do |t| t.column :user, :string end ?? execute "alter table ...." end Should the execute statement be above the table creation or below the table creation? Logically I
2006 Jul 03
2
redirect as post?
Hi, How can I make sure the redirect should act as a "POST" method and not as "GET"? Thanks, Hari -- View this message in context: http://www.nabble.com/redirect-as-post--tf1884434.html#a5151391 Sent from the RubyOnRails Users forum at Nabble.com.
2006 Jun 19
10
text_field_with_auto_complete doesn|t work in edit/show view
Hi, I am using the autocomplete for text field with ''Scriptaculous'' and it works perfectly fine in "new" action. All the examples I see are only for the "new" action. But doesn''t default to the selected value/text in "edit/show" action? Is this possible or should I write custom code for "edit/show" action? Thanks, Hari --
2006 May 28
7
Join table not being populated
Hello, I have the usual Categories and Products table scenario, mediated by a Categories_Products join table. When I create a new Product and into a given Category, I notice that my join table is not being populated. Shouldn''t the join Categories_Products table be populated? Thanks, gk -- Posted via http://www.ruby-forum.com/.
2006 May 21
3
has_many :through with a polymorphic join
Hi, Four tables: users, user_counties, uk_counties and us_counties. Each user has many counties, and each county has many users, so I decided to make user_counties a polymorph, so it can have counties from different countries (each country requires a completely different set of tables with a completely different set of properties, that''s why there''s one table for uk_counties and
2006 May 10
7
has_many :through scope on join attribute
Hi I have a has_many :through. It''s a basic mapping of Project id .... User id .... TeamMembers project_id user_id role What I would like to do is have different roles so I can have in the project model has_many :core_members, :through => :team_members, :source => :user but I would like to limit this to only those with the "core" role in the team members table for
2006 Jul 28
11
Forum
Im making forum and i have problem with paths. Here is code: http://pastie.caboo.se/6389 With this code, it works. But its a bit weird to use so many paths function. For every path i need to make new function. So can you suggest me something. Tables are like here: http://wiki.rubyonrails.com/rails/pages/ForumExample -- Posted via http://www.ruby-forum.com/.
2006 Jul 10
10
has_many :through and foreign key parameters
I just took my HABTM and turned it into a :through since my join table has another "non-joiny" attribute. I went from this: has_many_and_belongs_to :jobs, :join_table => ''tablename'', :foreign_key => ''x'', :association_foreign_key => ''y'' to this: has_many :jobs, :through =>
2006 Jun 05
3
Interactive debugging of rails models
Hi, How can I debug the models interactively? When I load the console using "ruby script/console", the changes in the models doesn''t get reflected. I have exit the console and reload the console everytime I make some changes. Is there a better way? Thanks, Hari -- Posted via http://www.ruby-forum.com/.
2006 Jul 11
4
how get a substring of a string
hello all i want to get the substring of a string i found a source that do it...but don''t work in my machine example "the source of ruby".chars[0..5] that must return "the so" -- Posted via http://www.ruby-forum.com/.
2006 Jul 04
2
has_many working correctly only on reload!
I have this code that is using svn externals with rails EDGE working fine for the past couple of months. A couple of days ago, this code died. Even after deleting vendor/rails, this code doesnt work: class Tag < ActiveRecord::Base has_many :taggings has_many :events, :through => :taggings has_many :users, :through => :taggings end class User < ActiveRecord::Base # Virtual
2006 May 06
3
Storing additional data on join tables with Rails
Hi there I need to store additional attributes on join table. Searching the Wiki [1] revealed two possible methods: 1) push_with_attributes, as described by Justin Palmer [2]. Unfortunately, "this method is now deprecated" [3]. Even if it wasn''t, there seem to be inherent problems with that approach, for example with updating those additional attributes, though Joshua Muheim
2006 May 16
4
Problems with multiple ''id'' columns in a join_table
I have a problem declaring a relationship through a join_table ; the SQL generated by ActiveRecord is correct, but there are two columns called ''id'', and the final object gets the ''wrong'' column ... Here''s a more detailed description of the data, code, and problem :- There''s a People table, with id, name, and a few things. Also a
2006 Jul 10
7
What is has_many :through really buying you over HABTM?
So having just learned how to do has_many :through as opposed to HABTM, and then, being concerned that I wouldn''t get it to work, I started thinking about these two approaches. It seems to me that the _only_ problem that the HM:T (has_many :through) approach solves that HABTM doesn''t is the issue of the potential collision of id columns between your join table and one of
2006 Apr 20
3
has_many :through with has_many/has_many join models
It seems that using a join model that joins with two has_many''s will fail to generate proper SQL class StudentSemesterRecord < ActiveRecord::Base belongs_to :semester has_many :discipline_records, :through => :semester end class Semester < ActiveRecord::Base has_many :student_semester_records has_many :discipline_records end class DisciplineRecord <
2006 May 31
6
habtm on an array (or object.habtm.habtm)
Hi, I have three Models: User, Group and File. User habtm groups and Group habtm Files How can I find all files that a particular user has access to? eg user.groups.files ? As user.groups returns an array, the above doesn''t work. Id like to find the files for all groups in that array, without adding any code to the User model. Thanks in advance PS I just posted this in the