Peter Rabbitson wrote:
> Will Hawes wrote:
>> Ah - I had expected the following to work, but it doesn't:
>>
>> my $where = {
>> datetime => {
>> "between",
>> [
>> \[ "to_date(?, 'YYYYMMDD HH24:MM:SS')", "$start 00:00:00" ],
>> \[ "to_date(?, 'YYYYMMDD HH24:MM:SS')", "$end 00:00:00" ]
>> ]
>> }
>> };
>>
>> It seems that while a reference to an arrayref can be used with
>> "between", elements within said arrayref are currently limited to
>> either scalars or references to scalars. Maybe a candidate for a
>> patch?
>>
>
> SQL::Abstract 1.59 just released on CPAN should nicely support all
> combinations of the above.
>
And SQL::Abstract 1.60 follows suit, as changes to the tester exposed subtle
problems with the tokenizer (no functional changes between 1.59 and 1.60).
_______________________________________________
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]
