Phlip wrote:
> dschruth wrote:
>
>> What if salary is not really a column in the database?
>>
>> What if it's a variable which is just a function of two other database
>> columns?
>
> Subscriber.calculate( :sum, :salary,
> :select => 'compensation + perks AS salary',
> :conditions => { :magazine_id => id } )
Occurs to me the :sum and :select might conflict.
Try also:
Subscriber.find( :first, :select => 'sum(compensation + perks) AS
salaries',
:conditions => { :magazine_id => id } )
You could also use :all, then group by 'magazine_id', to just rip them all at
once.
--~--~---------~--~----~------------~-------~--~----~
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 [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
