mysql - ruby on rails 中的 find_by_sql 报错

Question

我必须在 ruby​​ on rails 中获取列的值我使用 find_by_sql 在 mysql-cmd 中获取值该值正确返回但在 View 页面中它返回一个随机值

passed_question = params[:passed_question]
@answer.questions_id = passed_question
next_question = params[:next_question]
@question = Question.find_by_id(passed_question)
@module = Question.find_by_sql ["SELECT student_additional_field_id FROM questions WHERE id=#{passed_question}"]

它的127450632值但是在 mysql 命令中

mysql> select student_additional_field_id from questions
-> where id=3;
+-----------------------------+
| student_additional_field_id |
+-----------------------------+
|                           1 |
+-----------------------------+

提前致谢

Answer 1

因为find_by_sql会返回一个数组

您如何尝试从 result 访问值？

你试过这样吗

@module = Question.find_by_sql ["SELECT student_additional_field_id FROM questions WHERE id=#{passed_question}"]

student_additional_field_id = @module[0].student_additional_field_id