[CDBI] Use Literal SQL in part of a WHERE clause

Dave Mabe dmabe at runningland.com
Thu Feb 2 19:49:40 GMT 2006


Is there any way to use a where clause like this using CDBI::Sweet (without
using set_sql)?

WHERE TO_DAYS(now()) - TO_DAYS(created) < 2

Is there some way to insert literal SQL for an entire expression and not
simply the right hand side of one?  That is, I know you can do this:

    my $inn = 'is Not Null';
    my %where = (
        priority => { '<', 2 },
        requestor => \$inn
    );

but I'd like to use literal SQL for an entire expression.

TIA.
--
Dave Mabe
http://www.stocktickr.com/ - social stock trading
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digitalcraftsmen.net/mailman/private/classdbi/attachments/20060202/be24c3c1/attachment.html


More information about the ClassDBI mailing list