Custom query

M_I_R · February 1, 2010, 9:53am

Hi,
i want to select only product id and product name from a table how
will i manage please help

M_I_R · February 1, 2010, 10:10am

M I R wrote:

Hi,
i want to select only product id and product name from a table how
will i manage please help

Use

find_by_sql(SQL statement)

or use

find_by_product_id_and_product_name…

M_I_R · February 1, 2010, 10:37am

Use

find_by_sql(SQL statement)

You can also pass :select option to your find e.g.:

Product.find :all, :select=>“id, name”

Regards,
Rimantas