Search issue

I have a drop down list that has a value 'any'.
And I have this code in controller...

@results = Post.find(:all, :conditions => 'status = ?', @status)

There is no such value.

If any is selected, it means search for all records. What do I need to
put in variable @status to make so that it would search for all.

I can have multiple drop down lists in future with many combinations so
I cannot if statement here.

Oh yes you can :slight_smile: You just need to build up your conditions parameter bit by bit, eg

conditions = {}
if @status != 'any'
   conditions[:status] = @status
end

if @foo != 'any'
   conditions[:foo] = @foo
end

@results = Post.find :all, :conditions => conditions

You probably want to put most of this in the model.

Fred