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