From: Rajat Garg <rajat79@...>
Date: 2008-03-12T21:27:51+09:00
Subject: Active-Record Sql: selecting only few columns

------=_Part_8184_17628950.1205324879755
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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!

------=_Part_8184_17628950.1205324879755--