I tried my @b; push @b, $bla; my $rs = $self->{schema}->resultset('Jrn')->search_rs(undef, { -and => [ \["WHERE match(ti, ex, ad) against(? in boolean mode)", @b]], order_by => 'tri'});
and gets all the table back, not the row matching the criteria. Sorry but I really new to all these DBiC things. You mean there is no need to use SQL::Abstract at all ? or the $sql value are coming from there ? Could you be more explicit ? Thanks François > -----Original Message----- > From: Peter Rabbitson [mailto:rabbit+d...@rabbit.us] > Sent: jeudi, 3. avril 2014 16:04 > To: DBIx::Class user and developer list > Subject: Re: [Dbix-class] match against ... > > On Fri, Mar 28, 2014 at 03:46:05PM +0000, RAPPAZ Francois wrote: > > Hi there > > > > I haven't look deep enough in the doc pages, sorry, but how can I > > translate this with resultset('table')->search_rs(); > > > > SELECT * FROM table WHERE match(field1, field2, field3) > against('+$bla' in boolean mode) ORDER BY field1 ? > > Sorry for the late reply. There is no multi-parameter op support in > SQLA yet, due to the complexity of the corner cases (as you already > discovered). As suggested earlier in the thread - simply tell DBIC "in > this particular snippet - I'll drive": > > ->search( > { > criteria1 => val1, > criteria2 => val2, > -and => [ > \[ $sql, @bind ], > \[ $more_sql, @more_bind ], > ] > }, > { > order_by => ... > prefetch => ... > ... > }, > ); > > _______________________________________________ > List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class > IRC: irc.perl.org#dbix-class > SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ > Searchable Archive: http://www.grokbase.com/group/dbix- > cl...@lists.scsys.co.uk _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk