On Mar 12, 2008, at 8:27 AM, Rajat Garg wrote:
> 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 Garg
>
> Ph: 206-499-9495
> Add: 1314 Spring Street, #412
> Seattle, WA 98104
> 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 Biedenharn		http://agileconsultingllc.com
Rob / AgileConsultingLLC.com