Getting the "latest" related record from a SQL DB
matt.lawrence at virgin.net
Fri Oct 10 17:41:23 BST 2014
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:
More information about the london.pm