Hi, I tried with
*In View* <% @names.each do |name| %> <%= name.age %> <% name.cities.each do |city| %> <%= city.local_area %> <% name.countries.each do |country| %> <%= country.state %> <% end %> This shows no error with no output of city.local_area and country.state. On 23 September 2010 17:24, PalaniKannan K <[email protected]> wrote: > 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 <[email protected]> wrote: > >> On 23 September 2010 12:00, PalaniKannan K <[email protected]> >> 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 [email protected]. >> > To unsubscribe from this group, send email to >> > [email protected]<rubyonrails-talk%[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]<rubyonrails-talk%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/rubyonrails-talk?hl=en. >> >> > > > -- > With Regards > Palani Kannan. K > > -- 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 [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.
