does in fact give the list of all cities in the text field, but
def index
@cities = City.where("name like ?", "%#{params[:q]}%")
...
does NOT search cities at all.
Since above case works (though not incremental filter), the problem must
be the second query part.
But I don’t see any problem in the where clause. It does not raise any
errors at all. Simply, puts
be the second query part.
But I don’t see any problem in the where clause. It does not raise any
errors at all. Simply, puts
“No results”
City.all returns all cities. The second query matches the city name to
params[:q].
If params[:q] is empty, it will return all cities (at least that’s what
I
get when I
tried it on the console using postgre). If it isn’t empty, it will
match
for cities whose
names match params[:q]. If you’re using postgre, you may want to use
ilike
for
case insensitive matching.
does in fact give the list of all cities in the text field, but
def index
@cities = City.where("name like ?", "%#{params[:q]}%")
...
does NOT search cities at all.
If you look in log/development.log it will show you the database query
being run. If you still can’t see the problem then post the section
of the log for that action (including the query).
Cold you help me?
I got the same error, because params[:q] is empty.
How did you solve?
I did not solve it, I was just suggesting the route to go to diagnose
the problem. If you cannot see why params[:q] is empty then I suggest
starting a new thread and explaining the problem you are having.
If you are a beginner, however, then I suggest working right through a
good tutorial such as railstutorial.org (which is free to use online)
first in order to understand the basics of rails.
Colin
This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.