I think it fails because of the way it quotes the substituted value. I tend to code these slightly differently. I have cases where a Perl variable has a time interval in seconds, and I've stated the SQL as "some_date + ? * INTERVAL '1 SECOND'"
Then the variable containing the number of seconds is passed as the bind param. This isn't how one would code it as native SQL, maybe, but it works with the quoting scheme of DBIC/DBI/etc. Cheers. On 25 Sep 2013, at 00: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] _______________________________________________ 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]
