From: jackster the jackle <contact@...>
Date: 2008-08-16T00:34:15+09:00
Subject: Need to get average of specific fields in MySQL

Hi Forum,

My Active Record query works fine and pull all records where
ipadd='10.1.1.1' and print out the current_connection_count values but I
need to get the average of those numbers.

here is my Active Record config:
------------------
class Pix
end

device = Pix.find(:all, :conditions => "pixes.ipadd = '10.1.1.1'")
device.each do |line|
puts line.current_connection_count
end
------------------

Is it best to somehow change my sql query to get the average of these
numbers or is it better to try do it after the sql query (which I don't
know how to do either :-)) ?

any help would be appreciated.
thanks
jackster
-- 
Posted via http://www.ruby-forum.com/.