search for: match_id

Hi, I''ve two database tables 1-N related and one of them doesn''t have id column: matches (id, more columns), match_details(match_id, ... more columns) Also have two models that represents these tables: Match MatchDetail has_one :match_detail belongs_to :match, :foreign_key => ''match_id'' When I create a Match object with a new MatchDetail object...

...attr.attnum = dep.refobjsubid AND attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1] AND cons.contype = ''p'' AND dep.refobjid = ''match_comments''::regclass MatchComment Create (0.002280) INSERT INTO match_comments ("body", "match_id", "player_id", "inserted_at") VALUES(''testtest'', 159, 14, ''2006-03-16 12:22:55'') SQL (0.000684) SELECT currval(''public.match_comments_id_seq'') SQL (0.034973) COMMIT Redirected to http://tcuithof.laddertennis.n...

I''m trying to write a football prediction game. I have a Matches table and a Predictions table. Each Match :has_many Predictions, and each Prediction :belongs_to a Match Each Match has (amongst other things) a Match.match_date field. Each Prediction has (amongst other things) a User_id field I''m trying to get a list of all Predictions a particular User has made which

Hi, I''m working on an app - my first Rails - and am looking for some suggestions on the best way (or good way) to set up my models / DB. In general there are teams and matches; a team will participate in multiple matches, and in each match there will be 6 teams - 3 vs. 3. I''m going to want to be able, for a particular team, pull up all matches for that team, to display a

I''ve created a table in a SQL Server database using a migration, successfully. I''ve tried to change the name of a column in the table and got the error message above when running ''rake db:migrate''. Previously I have developed using MySQL and Sqlite and migrations have worked successfully. This is an error I have not seen before. Has anybody seen this and worked