sql query into ror query

[$wapnil Patil]

I want this query into ror form
select name from Batch where id = 1
i want only name
i tried
Batch.find(:all, :conditions => {:id => 1}) it works
but
Batch.find(:name, :conditions => {:id => 1}) not work
please give me suggestion

[Sanjiv Jha]

Batch.where(:id => 1).select(:name)

--
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 rubyonra...@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-ta...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

--
Josh Software Private Limited

6, Thube Park,

Shivaji Nagar,

Pune - 411005

Office: +91-020-25539995

[ppizzq]

I guess you are using Raiils 2.*,  in rails 2.x, it should be

Batch.find(:all, :conditions => {:id => 1}, :select => "name")

[Paul Lopez]

If you are using Rails 3, you can do

Batch.select(:name).find(1)

Either I will find a way or I shall make a way