Multi Row validation... or running queries within Validate f

Is there anyway to perform a query from within a validate function?

I need to verify that the sum of several rows does not exceed a certain
value eg:

class Entry < ActiveRecord::Base
belongs_to :day
belongs_to :project

    def validate
            totalhours = hours
            samedayentries = self.find_by_day_id(day_id)

            samedayentries.each do |i|
                           totalhours += i[:hours] unless (id == 

i[:id])
end
errors.add_to_base( “You cannot enter more than 24 hours
in a day.”) if totalhours > 24
end
end

Or some better way to accomplish the same general idea. (I can do it in
the controller, but it really belongs in the model IMHO.)

Thanks
Mark F.

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