getting error, Mysql2::Error: You have an error in your SQL syntax in rails?

Question

What needs to be changed in the below queries?. i want all those employees whose date_of_leaving is null or the date_of_leaving is in between the past 60 days or the date_of_leaving is greater than or equal to the Date.today or current date.

employees = @company.employees.where('date_of_leaving BETWEEN ? AND ? OR date_of_leaving IS NULL OR date_of_leaving IS >= Date.today', Date.today - 60, Date.today)

i tried in another way also like below.

employees = Company.find(4).employees.where('date_of_leaving BETWEEN ? AND ? OR date_of_leaving IS NULL OR date_of_leaving IS >= ?', Date.today - 60, Date.today,Date.today)

erik258 · Accepted Answer · 2016-12-30 12:44:32Z

1

I think your problem is the phrase IS >= .

You shouldn't use is with comparison operators. Just the operator. Take out that and it looks good otherwise.

answered Dec 30, 2016 at 12:44

erik258

16.5k2 gold badges32 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

getting error, Mysql2::Error: You have an error in your SQL syntax in rails?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related