Re: Table connection issue

PalaniKannan K
2010-09-23T15:24:45Z

Dear Colin,

Thanks for your correction. The error solved, but its not still showing the
values for

<%= city.local_area %>
<%= country.state %>

On 23 September 2010 17:11, Colin Law
<clanlaw-gM/Ye1E23mwN+BqQ9rBEUg@public.gmane.org> wrote:

> On 23 September 2010 12:00, PalaniKannan K
<kpalanikannan-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
> wrote:
> > Dear all,
> >
> > I included models, controller and View. Please, find the mistake in it
> and
> > tell me. I need to fetch the data of included tables "city and
country"
> > using the query of "first name and second name" of table
''name''.
> >
> > name model
> > has_many :city, :foreign_key => "name_id"
> > has_many :country, :foreign_key => "name_id"
>
> That should be :cities and :countries.  You don''t need the foreign
key
> spec, name_id is the default.
>
> Colin
>
> >
> > city model
> > belongs_to :name
> >
> > country model
> > belongs_to :name
> >
> > In Name Controller
> > @names = Name.find(:all, :conditions=>{:first_name =>
params[:gm],
> > :second_name => params[:sp]}, :include => [ :city, :country ])
> >
> > In Name View
> >
> > <% @names.each do |name| %>
> > <%= name.age %>
> > <% end %>
> >
> > <% @names.cities.each do |city| %>
> > <%= city.local_area %>
> > <% end %>
> >
> > <% @names.countries.each do |country| %>
> > <%= country.state %>
> > <% end %>
> >
> > --
> > With Regards
> > Palani Kannan. K
> >
> > --
> > 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
> > To unsubscribe from this group, send email to
> >
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org>
> .
> > 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
> To unsubscribe from this group, send email to
>
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org>
> .
> For more options, visit this group at
> http://groups.google.com/group/rubyonrails-talk?hl=en.