[CDBI] where clause in AbstractSearch

rahed h raherh at gmail.com
Wed Dec 13 15:30:22 GMT 2006


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

What's the right syntax like?

Thank you

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

More information about the ClassDBI mailing list