суббота, 2 апреля 2011 г.

Rails 3 find_by_sql multiple params

How to pass multiple params to the find_by_sql model method?

I've found this solution:

sql = "select q.id,q.date, qi.level from questions q, question_infos qi where q.date>=? and qi.level=?"

It's very simple:
Question.find_by_sql([sql, '2011-04-06', 1])