On 22 August 2010 23:04, Bob Smith <[email protected]> wrote:
Once again, please do not top post. Insert your reply a appropriate
points in the previous message. Thanks
> What I need returned is a list of the names in the fields name and
> sname put together in alphabetical order with their ids
> so I can make this list into an index screen with edit links. I assume
> the id would be Household.id, just looking for a way to combine
> two name fields for the index page.
I think I am slowly managing to get some grasp of what you are trying
to achieve, though it is proving very difficult to get information
from you.
Is it right that you want a view showing a list of households where
for each household you show the name which is a concatenation of two
fields from the household object? If so then you can do something
like
<% @households.each do |household| %>
<%= "#{household.name1} #{household.name2}" %>
<% end %>
However it would be better to provide a method oh Household that
returns the combined name so you can use
<%= household.combined_name %>
Colin
>
>
> Bob
>
> On Aug 21, 8:19 am, Colin Law <[email protected]> wrote:
>> 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
>> > 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.
