Tokeninput incremental search not working

Rails 3.1.3

After watching
http://railscasts.com/episodes/258-token-fields?autoplay=true
I have installed the similar functionality to my app.

However,

    def index
        @cities = City.all
        ...

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

"No results"

Can you guess where the problem is?

soichi

Rails 3.1.3

After watching
http://railscasts.com/episodes/258-token-fields?autoplay=true
I have installed the similar functionality to my app.

However,

    def index
        @cities = City.all
        ...

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

"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.

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).

Colin

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