What does the resulting SQL look like in your log?
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] 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 [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
