Rails syntax error

Question

Where is the error in this, I cannot see it:

news = News.find(:all, :conditions => [":simulation_id => session[:sim_id] AND :created_at > session[:last_login]"])

0

alamodey May 20 '09 at 14:26

3 answers

The condition string will not evaluate as you expect:

[":simulation_id => session[:sim_id] AND :created_at > session[:last_login]"]

change it to

["simulation_id = ? AND created_at > ?", session[:sim_id], session[:last_login]]

+1

Codebeef May 20 '09 at 14:34

You can also call Model.all

instead Model.find(:all)

, which will look something like this:

news = News.all(:conditions => ["simulation_id = ? AND created_at > ?", session[:sim_id], session[:last_login]])

0

Scott May 20 '09 at 18:31

Chris doggett · Accepted Answer · 2009-05-20T14:31:30+0000

Try the following:

news = News.find(:all, :conditions => ["simulation_id = ? AND created_at > ?", session[:sim_id], session[:last_login]])