[Dbix-class] patch: escaping user input - cookbook example

[Carl Franks]

On 06/02/2008, Matt S Trout <dbix-class at trout.me.uk> wrote:
> On Wed, Feb 06, 2008 at 10:34:09AM +0000, Carl Franks wrote:
> > Here's a minor patch to address an issue that I found a solution for
> > in the list archives, but couldn't find in the docs anywhere.
> >
> > It's against http://dev.catalyst.perl.org/repos/bast/DBIx-Class/0.08/trunk
> > if it should be against a different location and doesn't patch
> > cleanly, let me know and I'll fix it.
>
> { name => { like => $query } }
>
> works for that.

Did you maybe miss the leading and trailing '%' wildcards?

I just tried changing my app to use your code, and a search for "o'r"
no longer matched against "test o'reilly".

The code example in my patch came from one of your list responses:
http://www.mail-archive.com/dbix-class@lists.rawmode.org/msg03329.html

Carl