error in mysql code written for ruby on rails

Question

while running the below mysql query in ruby on rails

cnt=Domainurl.find_by_sql["SELECT MAX(`count`) FROM domainurls WHERE `domaindetail_id` = ?", @domain.id]
puts cnt.count

I am getting below error:

"error is: wrong number of arguments (0 for 1)"

Can anybody tell where exactly am I wrong?

Michelle Tilley · Accepted Answer · 2012-01-06 07:53:08Z

4

You either need to wrap the argument in parenthesis or add a space.

cnt=Domainurl.find_by_sql(["SELECT MAX(`count`) FROM domainurls WHERE `domaindetail_id` = ?", @domain.id])

or

cnt=Domainurl.find_by_sql ["SELECT MAX(`count`) FROM domainurls WHERE `domaindetail_id` = ?", @domain.id]

answered Jan 6, 2012 at 7:53

Michelle Tilley

159k40 gold badges379 silver badges312 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1