[CDBI] Using scalar functions with AbstractSearch

Matt S Trout dbix-class at trout.me.uk
Thu Feb 2 00:05:16 GMT 2006


On Thu, Feb 02, 2006 at 12:50:15AM +0100, Rhesa Rozendaal wrote:
> Dylan Vanderhoof wrote:
> >Trying to figure out a way to have an arbitrary where clause with
> >AbstractSearch/AbstractCount that includes a scalar function (Such as
> >NOW()).
> >
> >Is there any way to do this?  I haven't been able to find anything in
> >the documentation for SQL::Abstract or any of the other associated
> >modules that indicates this is possible.
> 
> According to the SQL::Abstract docs, you can do this by passing a reference 
> to a string:
> 
> 	some_date => \q{< now()},
> 
> I've even used something like this in CDBI::Sweet:
> 
> $class->search({
> 	q{now()} => \q{ between start_date and end_date }
> });

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

-- 
     Matt S Trout       Offering custom development, consultancy and support
  Technical Director    contracts for Catalyst, DBIx::Class and BAST. Contact
Shadowcat Systems Ltd.  mst (at) shadowcatsystems.co.uk for more information

 + Help us build a better perl ORM: http://dbix-class.shadowcatsystems.co.uk/ +




More information about the ClassDBI mailing list