thr3ads.net - Rails - self.where(''section = ?'', ''%:search

If this information is useful, please help other people find it:
Share via:

MDM

2010-Oct-31 00:39 UTC

self.where(''section = ?'', ''%:search_item%'')

I am trying to do a search where I can enter a part of a word and the
search find all occurrences of that part word in the field. The above
subject does not work. Can anyone help
I am using Rails 3 and ruby 1.9.2
I use to be able to do it in rails 2.x.
In my Model I have the following:-
  def self.search(search_item)
    if search_item
     self.where(''section = ?'',
''%:search_item%'')
    else
      self.all
    end
  end

In my controller I have:-
    @homepages = Homepage.search(params[:search])
    respond_to do |format|
      format.html # index.html.erb
      format.xml  { render :xml => @homepages }
      format.js {render :js => @homepages}
    end

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

Sampath Munasinghe

2010-Oct-31 03:20 UTC

head link

Re: self.where(''section = ?'', ''%:search_item%'')

self.where(''section = %?%'', search_item)





On Sun, Oct 31, 2010 at 7:39 AM, MDM
<don.mapp-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
> I am trying to do a search where I can enter a part of a word and the
> search find all occurrences of that part word in the field. The above
> subject does not work. Can anyone help
> I am using Rails 3 and ruby 1.9.2
> I use to be able to do it in rails 2.x.
> In my Model I have the following:-
>  def self.search(search_item)
>    if search_item
>     self.where(''section = ?'',
''%:search_item%'')
>    else
>      self.all
>    end
>  end
>
> In my controller I have:-
>    @homepages = Homepage.search(params[:search])
>    respond_to do |format|
>      format.html # index.html.erb
>      format.xml  { render :xml => @homepages }
>      format.js {render :js => @homepages}
>    end
>
> --
> You received this message because you are subscribed to the Google Groups
> "Ruby on Rails: Talk" group.
> To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
> To unsubscribe from this group, send email to
>
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org>
> .
> For more options, visit this group at
> http://groups.google.com/group/rubyonrails-talk?hl=en.
>
>
-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

MDM

2010-Oct-31 12:09 UTC

head link

Re: self.where(''section = ?'', ''%:search_item%'')

Thanks for that, but I am still getting a syntax error. Now:-
SQLite3::SQLException: near "%": syntax error: SELECT
"homepages".* FROM       "homepages"  WHERE     (section =
%''Gar''%)

This shows that the correct text is being passed, but the syntax is
still incorrect.
Don

On Oct 31, 3:20 am, Sampath Munasinghe
<sampathni...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:> self.where(''section = %?%'', search_item)
>
> On Sun, Oct 31, 2010 at 7:39 AM, MDM
<don.m...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
> > I am trying to do a search where I can enter a part of a word and the
> > search find all occurrences of that part word in the field. The above
> > subject does not work. Can anyone help
> > I am using Rails 3 and ruby 1.9.2
> > I use to be able to do it in rails 2.x.
> > In my Model I have the following:-
> >  def self.search(search_item)
> >    if search_item
> >     self.where(''section = ?'',
''%:search_item%'')
> >    else
> >      self.all
> >    end
> >  end
>
> > In my controller I have:-
> >    @homepages = Homepage.search(params[:search])
> >    respond_to do |format|
> >      format.html # index.html.erb
> >      format.xml  { render :xml => @homepages }
> >      format.js {render :js => @homepages}
> >    end
>
> > --
> > You received this message because you are subscribed to the Google
Groups
> > "Ruby on Rails: Talk" group.
> > To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
> > To unsubscribe from this group, send email to
> >
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org>
> > .
> > For more options, visit this group at
> >http://groups.google.com/group/rubyonrails-talk?hl=en.
>
>
-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

MDM

2010-Oct-31 12:10 UTC

head link

Re: self.where(''section = ?'', ''%:search_item%'')

Thanks for that, but I am still getting a syntax error. Now:-
SQLite3::SQLException: near "%": syntax error: SELECT
"homepages".* FROM       "homepages"  WHERE     (section =
%''Gar''%)

This shows that the correct text is being passed, but the syntax is
still incorrect.
Don

On Oct 31, 3:20 am, Sampath Munasinghe
<sampathni...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:> self.where(''section = %?%'', search_item)
>
> On Sun, Oct 31, 2010 at 7:39 AM, MDM
<don.m...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
> > I am trying to do a search where I can enter a part of a word and the
> > search find all occurrences of that part word in the field. The above
> > subject does not work. Can anyone help
> > I am using Rails 3 and ruby 1.9.2
> > I use to be able to do it in rails 2.x.
> > In my Model I have the following:-
> >  def self.search(search_item)
> >    if search_item
> >     self.where(''section = ?'',
''%:search_item%'')
> >    else
> >      self.all
> >    end
> >  end
>
> > In my controller I have:-
> >    @homepages = Homepage.search(params[:search])
> >    respond_to do |format|
> >      format.html # index.html.erb
> >      format.xml  { render :xml => @homepages }
> >      format.js {render :js => @homepages}
> >    end
>
> > --
> > You received this message because you are subscribed to the Google
Groups
> > "Ruby on Rails: Talk" group.
> > To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
> > To unsubscribe from this group, send email to
> >
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org>
> > .
> > For more options, visit this group at
> >http://groups.google.com/group/rubyonrails-talk?hl=en.
>
>
-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

Michael Pavling

2010-Oct-31 13:42 UTC

head link

Re: Re: self.where(''section = ?'', ''%:search_item%'')

On 31 October 2010 12:09, MDM
<don.mapp-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:> Thanks for that, but I am still getting a syntax error. Now:-
> SQLite3::SQLException: near "%": syntax error: SELECT
> "homepages".* FROM       "homepages"  WHERE    
(section = %''Gar''%)
>
You can''t put the question mark inside the percentage signs, as Rails
SQL-escapes the variable and wraps it in appropriate delimiters...
hence your error. You need to wrap your string in percentages one way
or another and pass that in:


self.where(''section = ?'', "%#{search_item}%")

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

MDM

2010-Oct-31 19:36 UTC

head link

Re: self.where(''section = ?'', ''%:search_item%'')

Thanks Michael
I have tried that along with other versions of
''%search_item%''without
any joy. Just tried it again. it does not throws an error, but it
returns nothing.
     self.where(''section = ?'', search_item) works with the
full word
''Gardening'', but not ''Gar''
     self.where(''section = ?'',
''%search_item%'') does not work and you
cannot use %without a '' or "
     self.where(''section = ?'',
''%''search_item''%'') is an internal
server error
     self.where(''section = ?'',
''%''+search_item+''%'') no go either.
Don

On Oct 31, 1:42 pm, Michael Pavling
<pavl...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:> On 31 October 2010 12:09, MDM
<don.m...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
>
> > Thanks for that, but I am still getting a syntax error. Now:-
> > SQLite3::SQLException: near "%": syntax error: SELECT
> > "homepages".* FROM       "homepages"  WHERE    
(section = %''Gar''%)
>
> You can''t put the question mark inside the percentage signs, as
Rails
> SQL-escapes the variable and wraps it in appropriate delimiters...
> hence your error. You need to wrap your string in percentages one way
> or another and pass that in:
>
> self.where(''section = ?'', "%#{search_item}%")
-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

Michael Pavling

2010-Oct-31 19:40 UTC

head link

Re: Re: self.where(''section = ?'', ''%:search_item%'')

On 31 October 2010 19:36, MDM
<don.mapp-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:> Thanks Michael
> I have tried that along with other versions of
''%search_item%''without
>     self.where(''section = ?'',
''%search_item%'') does not work and you
> cannot use %without a '' or "
Oops.... just spotted....
if you''re trying to do a SQL query with "%" you need to use
"LIKE"
instead of "="

   self.where(''section LIKE ?'', "%#{search_item}%")

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

MDM

2010-Oct-31 20:05 UTC

head link

Re: self.where(''section = ?'', ''%:search_item%'')

Wow Thanks Michael
After all this time.
Both of these works which do you think is best.
     self.where(''section LIKE ?'',
"%#{search_item}%")
     self.where(''section LIKE ?'',
''%''+search_item+''%'')
I can now get back to the remote => ajax call.
Pure joy Thanks again Don

On Oct 31, 7:40 pm, Michael Pavling
<pavl...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:> On 31 October 2010 19:36, MDM
<don.m...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
>
> > Thanks Michael
> > I have tried that along with other versions of
''%search_item%''without
> >     self.where(''section = ?'',
''%search_item%'') does not work and you
> > cannot use %without a '' or "
>
> Oops.... just spotted....
> if you''re trying to do a SQL query with "%" you need to
use "LIKE"
> instead of "="
>
>    self.where(''section LIKE ?'',
"%#{search_item}%")
-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

Michael Pavling

2010-Oct-31 21:30 UTC

head link

Re: Re: self.where(''section = ?'', ''%:search_item%'')

On 31 October 2010 20:05, MDM
<don.mapp-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:> Both of these works which do you think is best.
>     self.where(''section LIKE ?'',
"%#{search_item}%")
>     self.where(''section LIKE ?'',
''%''+search_item+''%'')
personally, I prefer the syntax of the first method; it seems more
"Ruby".

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

Marnen Laibow-Koser

2010-Nov-01 20:12 UTC

head link

Re: Re: self.where(''section = ?'', ''%:search_item%'')

Michael Pavling wrote in post #958364:> On 31 October 2010 20:05, MDM
<don.mapp-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
>> Both of these works which do you think is best.
>>   self.where(''section LIKE ?'',
"%#{search_item}%")
>>   self.where(''section LIKE ?'',
''%''+search_item+''%'')
>
> personally, I prefer the syntax of the first method; it seems more
> "Ruby".
It also performs slightly better, since it doesn''t create extra String 
objects.

Best,
--
Marnen Laibow-Koser
http://www.marnen.org
marnen-sbuyVjPbboAdnm+yROfE0A@public.gmane.org

-- 
Posted via http://www.ruby-forum.com/.

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

Reasonably Related Threads

Search for more seemingly similar threads

Rails - Oct 2010 - self.where('section = ?', '%:search_item%')

self.where(''section = ?'', ''%:search_item%'')

Re: self.where(''section = ?'', ''%:search_item%'')

Re: self.where(''section = ?'', ''%:search_item%'')

Re: self.where(''section = ?'', ''%:search_item%'')

Re: Re: self.where(''section = ?'', ''%:search_item%'')

Re: self.where(''section = ?'', ''%:search_item%'')

Re: Re: self.where(''section = ?'', ''%:search_item%'')

Re: self.where(''section = ?'', ''%:search_item%'')

Re: Re: self.where(''section = ?'', ''%:search_item%'')

Re: Re: self.where(''section = ?'', ''%:search_item%'')

Reasonably Related Threads