On 21 August 2010 08:40, Bob Smith <[email protected]> wrote: > 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.
Please don't top post, it makes it difficult to follow the thread. What do you mean a list of names and their id fields? You said that the names are fields in your model, so they do not have id's of their own. I asked that question last time and you have not answered it. Colin > > 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. > > -- 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.
