subgang
Posts: 9
|
| Posted: 02/29/2008, 9:40 AM |
|
I have a search field that allows the user to choose a number of days from a list, and filter results to show records from that number of days back.
How can I get this to work?
DATE_SUB(CURDATE(),INTERVAL {s_last_order_date} DAY)
If I use the above as an expression in the WHERE filter, it becomes this in the Codecharge code:
$this->DataSource->Parameters["urlDATE_SUB(CURDATE(),INTERVAL {s_last_order_date} DAY)"] = CCGetFromGet("DATE_SUB(CURDATE(),INTERVAL {s_last_order_date} DAY)", NULL);
which, of course, makes no sense...
|
 |
 |
|
