Hello,
Apologies for being a newbie, but could someone please help me with the correct
syntax for this mysql query:
select * from sessions where id='foo' and created > DATE_SUB(NOW(), INTERVAL 1
HOUR );
using DBIx in catalyst. I've tried such things as:
my $rs = $c->model('SmsDB::Session')->search({ -and => [
{ id => 'foo' },
{ created => { '<' => { 'DATETIME()' => { 'NOW()', 'INTERVAL 1 HOUR' } } } }
]})
and 1001 subtle variations thereof, but really I haven't a clue and would really
appreciate some help please!
Many thanks in advance,
Daniel
----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/[email protected]/
