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