Re: Table connection issue

Colin Law
2010-09-23T15:11:58Z

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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
> For more options, visit this group at
> http://groups.google.com/group/rubyonrails-talk?hl=en.