Active-Record Sql: selecting only few columns

Ruby
1

Hi Guys,

I am writing a sql query -
User.find(:all, :order=> ‘u.created_on DESC’, :limit =>2,
:joins => “as u left join photos p on u.id = p.user_id”)

But i want this query to return only 3 parameters (name, photo_url, id)
instead of all. Is there any ActiveRecord Way of selecting only those
fields.

I will really appreciate your help.

Thanks

–
Rajat G.

Ph: 206-499-9495
Add: 1314 Spring Street, #412
Seattle, WA 98104
Web: http://www.pilotoutlook.com

2

:select should be your friend here.

3

On Mar 12, 2008, at 8:27 AM, Rajat G. wrote:

Web: http://www.pilotoutlook.com

Flying is the second greatest thrill known to man. Landing is the
first!

Add a :select => ‘name, photo_url, id’ to your User.find, but be aware
that it means the User objects will be readonly since they don’t have
enough information to construct the SQL update command later.

-Rob

Rob B. http://agileconsultingllc.com
[email protected]