Table connection issue

PalaniKannan K
2010-09-23T11:00:43Z

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"
*
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 %>