I could be going about this all wrong but here goes.
I''m using a form to search my posts
The controller has:
def searchresults
search_term = params[''search'']
@posts_search = Post.find(:all, :conditions => ["title LIKE ?",
"%#{search_term}%"])
end
And in the view I have this:
<% form_tag :action => ''searchresults'' do %>
<%= text_field_tag :search %>
<%= submit_tag "Search" %>
<% end %>
Most terms, even single letters return the expected results. However,
it seems that whenever the search term contains the letters F or C, no
results are returned. There may be other letters that do the same,
but these are the only ones I''ve found so far. Any ideas to why this
is happening, or how can be fixed?
Many thanks in advance.
-Mike
--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
What does the resulting SQL look like in your log?
-----Original Message-----
From: rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
[mailto:rubyonrails-talk@googlegroups.com] On Behalf Of infinteVerve
Sent: Tuesday, October 14, 2008 10:44 AM
To: Ruby on Rails: Talk
Subject: [Rails] Searching - weird behavior with certain letters
I could be going about this all wrong but here goes.
I''m using a form to search my posts
The controller has:
def searchresults
search_term = params[''search'']
@posts_search = Post.find(:all, :conditions => ["title LIKE ?",
"%#{search_term}%"])
end
And in the view I have this:
<% form_tag :action => ''searchresults'' do %> <%=
text_field_tag :search %> <%= submit_tag "Search" %> <%
end %>
Most terms, even single letters return the expected results. However, it seems
that whenever the search term contains the letters F or C, no results are
returned. There may be other letters that do the same, but these are the only
ones I''ve found so far. Any ideas to why this is happening, or how can
be fixed?
Many thanks in advance.
-Mike
--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@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
-~----------~----~----~----~------~----~------~--~---
I am so dumb...
Of course, if there are now titles with the letter C there are no
results.
I forgot to change :conditions => ["title LIKE ?",
"%#{search_term}
%"])
to>
:conditions => ["post_body LIKE ? OR title LIKE ?",
"%#{search_term}
%", "%#{search_term}%"]
Sometimes the answer is too obvious.
On Oct 14, 1:48 pm, "Pardee, Roy"
<parde...-go57ItdSaco@public.gmane.org> wrote:> What does the resulting SQL look like in your log?
>
> -----Original Message-----
> From: rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
[mailto:rubyonrails-talk@googlegroups.com] On Behalf Of infinteVerve
> Sent: Tuesday, October 14, 2008 10:44 AM
> To: Ruby on Rails: Talk
> Subject: [Rails] Searching - weird behavior with certain letters
>
> I could be going about this all wrong but here goes.
>
> I''m using a form to search my posts
>
> The controller has:
> def searchresults
> search_term = params[''search'']
> @posts_search = Post.find(:all, :conditions => ["title LIKE
?",
> "%#{search_term}%"])
> end
>
> And in the view I have this:
> <% form_tag :action => ''searchresults'' do %>
<%= text_field_tag :search %> <%= submit_tag "Search" %>
<% end %>
>
> Most terms, even single letters return the expected results. However, it
seems that whenever the search term contains the letters F or C, no results are
returned. There may be other letters that do the same, but these are the only
ones I''ve found so far. Any ideas to why this is happening, or how can
be fixed?
>
> Many thanks in advance.
> -Mike
--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@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
-~----------~----~----~----~------~----~------~--~---