[Dbix-class] now() - interval ? placeholder trouble

[Dmitry L.]

Hello!

I consider, that you should use it this way:

$rs->search( { birth_time => { '<' => \["(now() - interval '1 hour')"] } } );


On 25 September 2013 03:10, Bob MacCallum <uncoolbob at gmail.com> wrote:
> Hello,
>
> I can't seem to (>1h banging head against wall) get this search
> condition working
>
> $interval = '1 hour';
> $rs->search(
> {
>  birth_time => { '<' => \[ "now() - interval ?", [interval => $interval] ] }
> }
> )->count
>
> Can anyone tell me what I'm doing wrong, please?
>
> For more, including the runtime error, please see
> http://paste.scsys.co.uk/269786
>
> thanks!
> Bob.
>
> _______________________________________________
> 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



-- 
//wbr, Dmitry L.