[CDBI] where clause in AbstractSearch

[rahed h]

Hello,

I can retrieve records from sqlite this way:
select id,col1 from mytable where date(mydate) = date('now');

This will return records as of today.

With Class::DBI I tried:
@records = Mymodule->search_where ('date(mydate)' => { '=', "date('now')"
});

but no records found. If I supply value as a string such as 2006-12-13, it's
ok.

What's the right syntax like?

Thank you

Radek
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digitalcraftsmen.net/pipermail/classdbi/attachments/20061213/11f4c71f/attachment.htm