I am trying to execute query below but I get an error.
Event.where("id IN ? and event_start_date > ?",[1, 2],Time.now)
I get error as follows:
SELECT "events".* FROM "events" WHERE (id IN 1,2 and event_start_date > '2015-03-11 04:40:43.819487')
PG::SyntaxError: ERROR: syntax error at or near "1"
LINE 1: SELECT "events".* FROM "events" WHERE (id IN 1,2 and event_s...
Parameter value is not consider as an array.
You have a syntax error. I think you can make your code easier to read, which would help prevent this kind of error:
Event.where({ id: [1, 2], event_start_date: Time.now })
In this format you pass a hash to the where query with id and event_start_date as the hash keys, and [1, 2] (an array) and Time.now as the values.
This is much more readable and easier to debug.
For a combination of an array argument and a range operation, I would do this as I find it more readable:
Event.where(id: [1, 2]).where("event_start_date > ?", Time.now)
@sank : your error gives your answer
there is syntax error in your query...
Instead of this
Event.where("id IN ? and event_start_date > ?",[1, 2],Time.now)
try this :
Event.where("id IN (?) and event_start_date > (?)",[1, 2],Time.now)
put () beside ?.
Event.where("id IN(?) AND event_start_date < (?)", [1,2,3], Time.now)
You're missing the () around the ? mark sign.
