search conversion
Hi Ray
$WADbSearch1->addComparisonFromEdit("DATE_FORMAT(OrderDate, '%Y-%m-%d 00:00:00')","OrderDate","AND","=",2);
was converted to
$searchWADAorders_1->setSearch(array("type"=>"Edit", "comparison"=>"=", "join"=>"AND"), array("DATE_FORMAT(OrderDate", "'%Y-%m-%d 00:00:00')"), "t", "OrderDate");
And when I do a search by date, I get this error
SELECT * FROM orders WHERE ((date(DATE_FORMAT(OrderDate) = ? OR date(`'%Y-%m-%d 00:00:00')`) = ?)) ORDER BY OrderID DESC
Incorrect parameter count in the call to native function 'DATE_FORMAT'
Not sure what it should be after the conversion?