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

On 21 August 2010 08:40, Bob Smith <bsm2th@gmail.com> 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 <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.
>
>

--
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.