hi,
i have to fire below query... SELECT * FROM clarify_crs c where c.id IN (select cscr.cscr_cr_id from clarify_case_crs cscr where cscr.cscr_case_id=10001);
I have to pass this 10001 as some variable. So i am using below query,
cs_id=params[:id] @lnkcr = Cl.find_by_sql('SELECT * FROM crs c WHERE c.id IN (SELECT cscr.cscr_cr_id FROM case_crs cscr WHERE cscr.cscr_case_id=?)',cs_id)
but i am getting error message saying that "wrong number of arguments (2 for 1)".
Please help. it is very important to me...