SQL Like operator in ruby on rails

Question

I had got a task to select search the students those name start with param value and city in the selected value.How can i set in ruby on rails? i did like this but this is not working controller

 def list

    studentcount=Student.count()
    puts studentcount
    @studentname = Student.where("name name1 AND city = :cityId1",
    {:name1 => params[:name], :cityId1 => params[:cityId]})

    puts 'studentname'
    puts @studentname.inspect
    @students = Student.limit(params[:jtPageSize]).offset(params[:jtStartIndex]).order(params[:jtSorting])

    @jtable = {'Result' => 'OK','Records' => @students.map(&:attributes), :TotalRecordCount => studentcount}

    respond_to do |format|
      format.html # index.html.erb
      format.json { render :json => @jtable}
    end
  end

Christoph Petschnig · Accepted Answer · 2012-12-07 07:47:45Z

14

Try:

@studentname = Student.where("name LIKE :name1 AND city = :cityId1",
  {:name1 => "#{params[:name]}%", :cityId1 => params[:cityId]})

This is a rather dirty solution, but pure ARel cannot handle this case the way you desire. You might want to try the Sqeel gem.

answered Dec 7, 2012 at 7:47

Christoph Petschnig

4,1873 gold badges39 silver badges46 bronze badges

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

1 Comment

Nithin Viswanathan Over a year ago

Can you help me to write if statement for the cityid==0

monteirobrena · Accepted Answer · 2015-08-11 12:23:37Z

5

Try

@studentname = Student.where("name LIKE ? AND city = ?", "#{params[:name]}%", params[:cityId])

edited Aug 11, 2015 at 12:23

monteirobrena

2,6301 gold badge35 silver badges47 bronze badges

answered Dec 7, 2012 at 7:43

Sandip Karanjekar

8601 gold badge6 silver badges23 bronze badges

1 Comment

sevenseacat Over a year ago

This will make sure the name ends with the value, not begins with it.

Richie Min · Accepted Answer · 2012-12-07 07:43:20Z

-1

there is a error in your methods, it should be like this

  @studentname = Student.where("name = :name1 AND city = :cityId1",
     {:name1 => params[:name], :cityId1 => params[:cityId]})

answered Dec 7, 2012 at 7:43

Richie Min

6545 silver badges15 bronze badges

Collectives™ on Stack Overflow

SQL Like operator in ruby on rails

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related