English 中文(简体)
简单查询仅查询记录最后一字
原标题:Simple search only searching last word of record

我根据第240号铁路计划的一部分指示进行了简单搜查。

in controller

 @reports = Report.search(params[:search]).order( created_at DESC ).paginate(:page => params[:page], :per_page => 5)

模型

  def self.search(search)
    if search
      where( apparatus LIKE ? , "%#{search}") 
    else
      scoped
    end
  end

目 录

<%= form_tag reports_path, :method => :get do %>
    <p>
        <%= text_field_tag :search, params[:search] %>
        <%= submit_tag "Search", :name => nil %>
    </p>
<% end %>

it all works... but...
I have a few records for example, one with "another time test" and another with "last test of time"
if i search "test" the first comes up but the second doesn t, and if i search "time" the second comes up but not the first. It is only seeing the last word of the record.

什么?

最佳回答

你们需要在搜寻术语的两边打上百分之百的信号。 与此类似:

where( apparatus LIKE ? , "%#{search}%")

在搜索之前用百分率表示,你将一切照旧作为野心。 然而,你还再次指出,在搜索之后,不应再将任何东西视为野心。 因此,它只与最后的措辞一致。

问题回答

暂无回答




相关问题
rails collection_select vs. select

collection_select and select Rails helpers: Which one should I use? I can t see a difference in both ways. Both helpers take a collection and generates options tags inside a select tag. Is there a ...

SSL slowness in EC2

We ve deployed our rails app to EC2. In our setup, we have two proxies on small instances behind round-robin DNS. These run nginx load balancers for a dynamically growing and shrinking farm of web ...

Auth-code with A-Za-z0-9 to use in an URL parameter

As part of a web application I need an auth-code to pass as a URL parameter. I am currently using (in Rails) : Digest::SHA1.hexdigest((object_id + rand(255)).to_s) Which provides long strings like : ...

RubyCAS-Client question: Rails

I ve installed RubyCAS-Client version 2.1.0 as a plugin within a rails app. It s working, but I d like to remove the ?ticket= in the url. Is this possible?

activerecord has_many :through find with one sql call

I have a these 3 models: class User < ActiveRecord::Base has_many :permissions, :dependent => :destroy has_many :roles, :through => :permissions end class Permission < ActiveRecord::...

Ordering a hash to xml: Rails

I m building an xml document from a hash. The xml attributes need to be in order. How can this be accomplished? hash.to_xml

Text Editor for Ruby-on-Rails

guys which text editor is good for Rubyonrails? i m using Windows and i was using E-Texteditor but its not free n its expired now can anyone plese tell me any free texteditor? n which one is best an ...

How to get SQL queries for each user where env is production

I’m developing an application dedicated to generate statistical reports, I would like that user after saving their stat report they save sql queries too. To do that I wrote the following module: ...

热门标签