Displaying 1 result from an estimated 1 matches for "admin_yn".
Did you mean:
admin_q
2007 Jul 09
3
NoMethodError when using find_by_sql
I''m try to verify users on login. Here is my code:
def self.authenticate(username,password,account_code)
employee = self.find(:all,
:select => "e.id, e.first_name, e.last_name, e.username,
e.account_id, e.department_id, o.pay_type_id, o.admin_yn, o.payroll_yn,
o.files_yn, o.dept_report_yn,e.salt, e.hashed_password",
:conditions => ["e.deleted_yn=0 and e.username = ? and
a.account_code = ?", username, account_code],
:joins => "as e left outer join options o on e.id = o.employee_id
left outer join accoun...