Re: [CDBI] Using scalar functions with AbstractSearch

> >Why not just use { -between => [ $start, $end ] } ?

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@xxxx.xxx

_______________________________________________
ClassDBI mailing list
ClassDBI@xxxxx.xxxxxxxxxxxxxxxx.xxx
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi