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/[email protected]
