Table connection issue

Rails
1

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

–
With Regards
Palani Kannan. K

2

On Sep 23, 12:00 pm, 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’.

You could start by stating what the problem is rather than leaving
people to guess.

Fred

3

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

4

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 L. [email protected] wrote:

has_many :city, :foreign_key => “name_id”

<%= name.age %>

For more options, visit this group at
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

–
With Regards
Palani Kannan. K

5

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:

has_many :city, :foreign_key => “name_id”

<%= name.age %>

.
.

–
With Regards
Palani Kannan. K

6

On 23 September 2010 16:35, PalaniKannan K [email protected]
wrote:

Please don’t top post it makes it difficult to follow the thread,
thanks.

<% name.countries.each do |country| %>
<%= country.state %>
<% end %>

This shows no error with no output of city.local_area and country.state.

Are you sure it is finding any cities and countries? Try displaying
name.cities.count and the same for countries. Even better have a look
at the Rails Guide on debugging and use ruby-debug to break in and
examine the variables.

Colin