Is there any reason that foreign key fields do not show in any of the scaffold views ? project table: id serial primary key, category_id integer, user_id integer, name varchar, morestuff varchar foreign key (category_id) references categories(id), foreign key (user_id) references users(id) scaffold generated views only show name, morestuff fields
on 2006-01-13 08:23
on 2006-01-13 15:36
John: I don't know the reason, but if it puts your mind at rest, you are doing nothing wrong. This is the way it is with scaffolding. It is very easy to add foreign key fields to the existing scaffolding. Just follow the pattern laid out by the fields that are there and use something like collection_select to get a drop down to work with the linked tables. bruce
on 2006-01-13 18:51
John John wrote: > Is there any reason that foreign key fields do not show in any of the > scaffold views ? > > project table: > id serial primary key, > category_id integer, > user_id integer, > name varchar, > morestuff varchar > foreign key (category_id) references categories(id), > foreign key (user_id) references users(id) > > scaffold generated views only show name, morestuff fields From what I read, scaffold causes rails to hide anything named id or ending with _id. If you want, say, dropdown menus from lookup tables ( I needed these. Took a long time to figure out how to do ) try this: <%= options_from_collection_for_select(Yourmodel.find(:all, :order => "id"), :id, :lookupField, selected_value= someIDhere) %></select> someIDhere in my cases was the foreign key field in the parent table. This allowed me to get it to select the right entry for that record. options_from_collection_for_select is in the rails API. You'll be spending a LOT of time sifting through that if you plan to stick it out in rails. Good luck.
on 2006-01-13 21:22
On 1/12/06, John T. <email@example.com> wrote: > foreign key (user_id) references users(id) > > scaffold generated views only show name, morestuff fields If you want the user and category for the project scaffolded with a select box, you can look into the Scaffolding Extensions plugin.
on 2006-01-13 22:02
Thank you. It would be helpful if someone could write an article on all the Rails extras that are available - I think some of us are missing out on a lot of features.