FAQ
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
moseley at hank.org


_______________________________________________
List: Catalyst at lists.rawmode.org
Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst at lists.rawmode.org/
Dev site: http://dev.catalyst.perl.org/

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 2 | next ›
Discussion Overview
groupcatalyst @
categoriescatalyst, perl
postedAug 17, '06 at 3:58a
activeAug 17, '06 at 6:52a
posts2
users2
websitecatalystframework.org
irc#catalyst

2 users in discussion

Hideo Kimura: 1 post Bill Moseley: 1 post

People

Translate

site design / logo © 2022 Grokbase