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
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:
