[Rails] Re: Trying to make a user list from 2 fields

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 <clan...@googlemail.com> wrote:
> On 20 August 2010 06:41, Bob Smith <bsm...@gmail.com> 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 rubyonrails-talk@googlegroups.com.
> > To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
> > 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 rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.