How do I access a child table/model from the parent in sql s

Alexei Spirit wrote:

Alexei Spirit wrote:

Something like this:

Manufacturer.all :joins => :description, :conditions => {:descriptions
=> {:locale => I18n.locale}}

Version with :order

Manufacturer.all :joins => :description, :order => :name, :conditions =>
{:descriptions => {:locale => I18n.locale}}

Thank you so much.

I did this based upon what you wrote above and it works great.

find(:all, :joins => :descriptions, :order => :name, :conditions =>
{:descriptions => {:locale => I18n.locale}})

Thanks again.

Mitchell Gould wrote:

Alexei Spirit wrote:

Alexei Spirit wrote:

Something like this:

Manufacturer.all :joins => :description, :conditions => {:descriptions
=> {:locale => I18n.locale}}

Version with :order

Manufacturer.all :joins => :description, :order => :name, :conditions =>
{:descriptions => {:locale => I18n.locale}}

Thank you so much.

I did this based upon what you wrote above and it works great.

find(:all, :joins => :descriptions, :order => :name, :conditions =>
{:descriptions => {:locale => I18n.locale}})

Thanks again.

One last question.
I need the description for the manufacturer that is found in the table
descriptions. How do I get this columns info and how do I access it in
the view?

Thank you in advance

One last question.
I need the description for the manufacturer that is found in the table
descriptions. How do I get this columns info and how do I access it in
the view?

Thank you in advance

With this one:

find(:all, :joins => :descriptions, :order => :name, :conditions =>
{:descriptions => {:locale => I18n.locale}})

since you descript your associations you can get manufacturers with all
associated models, then you can use it anywhere

Like this one for example:

@manufacturers = Manufacturer.all :joins => :description, :order =>
:name, :conditions => {:descriptions => {:locale => I18n.locale}}

@manufacturers.each do |manufacturer|
  puts manufacturer.description.description
end

I suppose this would very helpfull for u:
http://guides.rubyonrails.org/active_record_querying.html

Alexei Spirit wrote:

I suppose this would be very helpfull for u:
http://guides.rubyonrails.org/active_record_querying.html

Yes Alexei that is the perfect guide. Thanks again.