[Dbix-class] match against ...

[RAPPAZ Francois]

At the end, this was working

	my $bla = $b->get_text();
	($bla=$bla)=~s/\s+/ \+/g;
	my @b; 
	push @b, $bla;
	my $rs = $self->{schema}->resultset('Jrn')->search(\[ "match (ti, ex, ad) against(? in boolean mode)", @b], {order_by => 'tri'});

F.

> -----Original Message-----
> From: Will Crawford [mailto:billcrawford1970 at gmail.com]
> Sent: vendredi, 4. avril 2014 16:57
> To: DBIx::Class user and developer list
> Subject: Re: [Dbix-class] match against ...
> 
> On 4 April 2014 15:27, RAPPAZ Francois <francois.rappaz at unifr.ch>
> wrote:
> > I tried
> ...
> > my $rs = $self->{schema}->resultset('Jrn')->search_rs(undef, { -and
> => [ \["WHERE match(ti, ex, ad)  against(? in boolean mode)", @b]],
> order_by => 'tri'});
> 
> Take out the "undef, " -- you've passed the query as the second
> parameter.
> 
> _______________________________________________
> 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 at lists.scsys.co.uk