[CDBI] Using scalar functions with AbstractSearch

Bill Moseley moseley at hank.org
Thu Feb 2 01:22:00 GMT 2006


On Thu, Feb 02, 2006 at 01:07:13AM +0100, Rhesa Rozendaal wrote:
> >Why not just use { -between => [ $start, $end ] } ?
> >
> 
> Because in this case "start_date" and "end_date" are columns in the table.
> I tried to get a search with several other criteria, and the fixed string 
> "start_date < now() and end_date > now()" or something to that effect.
> The above way was the first thing I got working in Sweet.

Do you mean this?


$ perl -MData::Dumper -MSQL::Abstract -le "print Dumper [SQL::Abstract->new->where( { foo => 'bar', start => {'<', 'now()'}, end => { '>=', 'now()'} } )]"
$VAR1 = [
          ' WHERE ( end >= ? AND foo = ? AND start < ? )',
          'now()',
          'bar',
          'now()'
        ];



-- 
Bill Moseley
moseley at hank.org





More information about the ClassDBI mailing list