All I need is a list of names and their id field so I can setup links to edit them from the view. The problem is that there are two name lists. I need to combine them and have either rails or SQL order them alphabetically.
On Aug 20, 4:51 am, Colin Law <[email protected]> wrote: > On 20 August 2010 06:41, Bob Smith <[email protected]> wrote: > > > My model has twofieldsthat I want in a customerlistfor an index > > page. They are name and second_name. I need a way to combine them in a > > collection with their id numbers so the Edit links will work. Sounds > > like SQL, but I'm not sure. > > I don't understand what you mean by 'their id numbers'. The household > record will have an id but the individualfieldsdo not, they just > have the text of the name and second_name. Perhaps you are talking > about relationships to other models rather thanfieldsin the model? > If so then we need to know the relationships. > > Colin > > > > > maybe something like: > > SELECT name, id FROM households and SELECT second_name, id FROM > > households > > > just not sure how to make ONE statement from these two including > > both... > > > Thanks > > > Bob > > > -- > > 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 [email protected]. > > To unsubscribe from this group, send email to > > [email protected]. > > For more options, visit this group > > athttp://groups.google.com/group/rubyonrails-talk?hl=en. -- 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
