How can I put conditionals in my controller?

Question

I'm having problems when I'm trying to put a condition in params in my controller. This code is inside my controller:

if params[:example] == 1
   @table = Model.find(:all,:conditions=>['column_table= ?',params[:example]  ]  )
else
   @table = Model.find(:all,:conditions=>['column_table2= ?',params[:example]  ]  )
end

Is this code correct? How can I put a conditional in params controller?

First of all check raise params[:example].inspect – user2310209 Sep 27 '13 at 05:39 — user2310209, Sep 27 '13 at 05:39
what problem are you having , show the error.. – tihom Sep 27 '13 at 05:46 — tihom, Sep 27 '13 at 05:46

score 2 · Accepted Answer · answered Sep 27 '13 at 06:27

2

You code looks okay. Unfortunately you do not say what problem you have. The only thing I see that may fail is the condition. If you pass some value into your params they are not typecasted. Therefore I guess you should use to_i in your condition:

if params[:example].to_i == 1
  ...

answered Sep 27 '13 at 06:27

spickermann

100,941
9
101
131

THanks spickermann it worked for me – Charlie Brown Sep 27 '13 at 14:22

score 1 · Answer 2 · answered Sep 27 '13 at 05:42

1

Try with

@table = Model.where((params[:example] == 1 ? 'column_table= ?' : 'column_table2 = ?'), params[:example]) unless params[:example].blank?

answered Sep 27 '13 at 05:42

Bachan Smruty

5,686
1
18
23

score 1 · Answer 3 · answered Sep 27 '13 at 05:43

Here is code. You have save params[:example] in one variable.and use your coditions.

if params[:example].present?
    @example = params[:example]
   if @example == 1
    @table = Model.find(:all,:conditions=>['column_table= ?',params[:example]  ]  )
    else
   @table = Model.find(:all,:conditions=>['column_table2= ?',params[:example]  ]  )
end

score 1 · Answer 4 · answered Sep 27 '13 at 05:49

1

You can also send the column name along with its value and avoid ifs

@table = Model.find(:all,:conditions=>["#{params[:col]} = ?", params[:example]  ]  )

answered Sep 27 '13 at 05:49

techvineet

5,041
2
30
28

thanks is another help :) – Charlie Brown Sep 27 '13 at 14:24

How can I put conditionals in my controller?

4 Answers4