Thanks guys - can't try the suggestions right now but I'm pretty sure they will work!
On Wed, Sep 25, 2013 at 10:18 AM, Dmitry L. <[email protected]> wrote: > 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 <[email protected]> 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/[email protected] > > > > -- > //wbr, Dmitry L. > > _______________________________________________ > 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] _______________________________________________ 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]
