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/
