Rails syntax error

Question

Where is the error in this I can't see it:

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

Chris Doggett · Accepted Answer · 2009-05-20 14:31:30Z

5

Try this:

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

answered May 20, 2009 at 14:31

Chris Doggett

21k4 gold badges63 silver badges87 bronze badges

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

Comments

Codebeef · Accepted Answer · 2009-05-20 14:43:12Z

1

Your conditions string won't be evaluated as you expect:

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

change that to

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

answered May 20, 2009 at 14:34

Codebeef

44.1k23 gold badges90 silver badges119 bronze badges

simulation_id should be '=', not '=>'

Scott · Accepted Answer · 2009-05-20 18:31:54Z

0

You can also call Model.all instead of Model.find(:all) which would look something like this:

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

answered May 20, 2009 at 18:31

Scott

6545 silver badges10 bronze badges