Ruby on Rails

On 31 October 2010 12:09, MDM <don.mapp@gmail.com> 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@googlegroups.com.
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.