[CDBI] where clause in AbstractSearch
"rahed h" <[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.class-dbi |
|---|---|
| Message-ID | <[email protected]> |
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
_______________________________________________
ClassDBI mailing list
ClassDBI-Ra3b/[email protected]
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi