Doing a SQL sum and getting the result into rails


I am trying to execute the following SQL code and have the result
returned to my application for further proessing…

“select SUM(action) as ‘sum’ from approvals where upload_id = ?”,

I have tried this in a Approval.find_by_sql also as a
Approval.connection.execute, but I can’t seem to get the data back
into rails… How can I access the returned data, which should be a
single number? I tried @points.sum, @points, etc. I want to do some
numerical comparisons on this, so I need the number, and just the

Oh, and action can be any number from -3 to 3, so I can’t just do a

Any ideas?


Approval.sum ‘action’, :conditions => [‘upload_id = ?’,]
should do the trick.

If you go down the road of writing out the sql by hand (not necessary
here, but things aren’t always as simple) then you can use


This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs