Hi,
I posted following suggestion to DBIC ML before.
my $aginst = 'foo';
my $rs = $schema->resultset('Articles')->search(
{},
{order_by => 'id desc', page => 1, limit => 10}
)->search_literal('MATCH (title, body) AGAINST( ? )', $aginst);
I dunno this is the best practice, but it works fine
in my environment.
hide.
>
> Any tricks to get SQL::Abstract to setup MySQL's fulltext search:
>
> MATCH (foo,bar) AGAINST ('+word -notword' IN BOOLEAN MODE)
>
> with proper bind parameters?
>
>
> --
> Bill Moseley
> [EMAIL PROTECTED]
>
>
> _______________________________________________
> List: Catalyst@lists.rawmode.org
> Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
> Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/
> Dev site: http://dev.catalyst.perl.org/
_______________________________________________
List: Catalyst@lists.rawmode.org
Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/
Dev site: http://dev.catalyst.perl.org/
