quarterIdThe = params[:quarterThe_id].to_s #得到--本季度操作--對話框 department = params[:department_id] #得到選擇的部門名稱 upThe,downThe = getUpTheDownThe(quarterIdThe) #這是我自己寫的一個方法，沒有錯誤 busiesses = Business.find_by_sql["SELECT d.name FROM businesses AS b JOIN employees AS e ON (b.employee_id = e.id) JOIN departments AS d ON (e.department_id = d.id) WHERE d.code = Department AND b.out_date <= UpThe AND b.out_date > DownThe ",{:Department => 'department',:UpThe=> 'upThe',:DownThe=> 'downThe'}] 我用的rails，這是在控制里面寫的代碼，主要是find_by_sql后邊的代碼有問題，總是提示說參數個數錯誤，求各位幫忙解決，或者是在model中寫這個方法的話代碼應該怎樣寫
2 回答
蝴蝶刀刀
TA貢獻1801條經驗 獲得超8個贊
Business.find_by_sql["SELECT d.name FROM businesses AS b
JOIN employees AS e ON (b.employee_id = e.id)
JOIN departments AS d ON (e.department_id = d.id)
WHERE d.code = ? AND b.out_date <= ? AND b.out_date > ?", department, upThe, downThe]
慕尼黑的夜晚無繁華
TA貢獻1864條經驗 獲得超6個贊
{:Department => 'department',:UpThe=> 'upThe',:DownThe=> 'downThe'}
你怎么這樣寫。。
api
# You can use the same string replacement techniques as you can with ActiveRecord#find
Post.find_by_sql ["SELECT title FROM posts WHERE author = ? AND created > ?", author_id, start_date]
> [#<Post:0x36bff9c @attributes={"first_name"=>"The Cheap Man Buys Twice"}>, ...]
添加回答
舉報
0/150
提交
取消