On 10/10/14 13:21, David Cantrell wrote:
On Thu, Oct 09, 2014 at 04:56:22PM +0000, Adam Witney wrote:Could you select all albums, ORDER BY date DESC LIMIT 1 ?I don't think that LIMIT is standard SQL so it won't be supported everywhere. And also I don't think that useful things like DBIx::Class support it.
The feature is very widely supported, but the syntax varies. DBIx::Class abstracts that away from you with the 'rows' parameter:
https://metacpan.org/pod/DBIx::Class::ResultSet#rows Matt
