[Note: parts of this message were removed to make it a legal post.]

Hi Guys,

I am writing a sql query -
User.find(:all, rder=> '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 .

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!

:select should be your friend here.

On Wed, 12 Mar 2008 21:27:51 +0900, Rajat Garg wrote:
> Hi Guys,
>
> I am writing a sql query -
> User.find(:all, rder=> '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 .
>
> Thanks

On Mar 12, 2008, at 8:27 AM, Rajat Garg wrote:
> Hi Guys,
>
> I am writing a sql query -
> User.find(:all, rder=> '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 .
>
> 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