Can anyone see what is wrong with this code?

Using find by sql to get some results. The error is:

wrong number of arguments (0 for 1)
#{RAILS_ROOT}/app/models/result.rb:24:in `find_by_sql’

def self.get_tests_run(project)
@project = Project.find(project)
@builds = []
@results = []
@project.testsuite.each do |testsuite|
testsuite.build.each do | build|
@builds << build.id
end
end
now = Date.today
count = 7
7.times do
@results << Result.find_by_sql[“SELECT count(distinct(tcid)) FROM
results WHERE build_id in (?) and daterun <= ?”, @builds,
Date.new(now.year,now.month,now.day - count) ]
count -= 1
end
@results
end

I cannot see what is wrong with that find_by_sql statement.

thanks

RJ

Missing parentheses around the argument. You have square brackets for
the SQL
parameter substitution but no () for the argument list.

Neha C. wrote:

@results = []

Date.new(now.year,now.month,now.day - count) ]


Posted via http://www.ruby-forum.com/.


View this message in context:
http://www.nabble.com/Can-anyone-see-what-is-wrong-with-this-code--tf3454521.html#a9638351
Sent from the RubyOnRails Users mailing list archive at Nabble.com.