bingo bob wrote: >> An unlimited amount? > > Well yes, I believe so. In the vast majority of cases people just have > firstname surname, also firstname middlename surname. But in essence > they could have 100 middle names; although it's a little unlikely I > don't believe there are legal constraints here in the UK. > > Pragmatically though - > I think I'll go with a minor adaptation(s) of your first solution.. > > ProposedNames table with the following columns: > > user_id :integer > forename :string > midname1 :string > midname2 :string > midname3 :string > midname4 :string > midname5 :string > surname :string > gender :string > > Really appreciate your other points re how I might handle the form and > logic. Got to love railscasts, I'd be nowhere without them, they are > truly excellent.
I agree with your proposed structure. It would be my recommendation, but you did specify 'unlimited'. It seems *pointless* for a human to have > 7 names. Apologies for omitting the midname column from my original recommendation. -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-t...@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.