Search for item name from multiple fields on Ruby on Rails

Question

I'm trying to enable a search for an item, and then have that item listed if the search is completed. I can get it to work for both instances, but not at the same time. My code:

def search
    @results=0
        if !params[:searchinput].empty?
            @results=1
            @searchinput = params[:searchinput]
            @searchcriteria="%#{params[:searchinput]}%"
            @productlist = Product.where("productname like ? OR description like ?", @searchcriteria)
    end
end

I get the following error: Is the formatting with the productlist statement wrong?

If you want to use the same term for both ?s, you need to pass @searchcriteria twice; otherwise it thinks you forgot one. — philomory
– philomory, Commented Oct 19, 2016 at 1:19
@philomory I don't know how that passed over my head. Thanks! — Frank
– Frank, Commented Oct 19, 2016 at 1:21

C dot StrifeVII · Accepted Answer · 2016-10-19 01:22:57Z

2

The problem is you have to pass in two variables. If that is @searchcriteria then pass that in.

def search
    @results=0
        if !params[:searchinput].empty?
            @results=1
            @searchinput = params[:searchinput]
            @searchcriteria="%#{params[:searchinput]}%"
            @productlist = Product.where("productname like ? OR description like ?", @searchcriteria, @second_variable)
    end
end

answered Oct 19, 2016 at 1:22

C dot StrifeVII

1,8851 gold badge16 silver badges21 bronze badges

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

Comments

Frank · Accepted Answer · 2016-10-19 01:23:10Z

0

the productlist statement should look like the following:

@productlist = Product.where("productname like ? OR description like ?", @searchcriteria, @searchcriteria)

answered Oct 19, 2016 at 1:23

Frank

3491 gold badge8 silver badges19 bronze badges

Collectives™ on Stack Overflow

Search for item name from multiple fields on Ruby on Rails

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related