manuel
Posts: 48
|
Posted: 06/04/2013, 8:23 PM |
|
How can I filter the form data based on current date, I tried adding a WHERE clause to the "Data Source" with now(), CURDATE(), etc. but it sends an error.
There's a special clause in CCS for this? I cant do this in the DDBB (only read access)
using php+mysql
|
|
|
Lucius
Posts: 220
|
Posted: 06/05/2013, 8:29 AM |
|
What is the full SQL constructed for the form, when you try to add some condition based on the date?
|
|
|
manuel
Posts: 48
|
Posted: 06/05/2013, 2:23 PM |
|
I used CCS query builder, choose only 1 table, a few fields, and two where clause's: 1 based on the url (worked fine) and the other based on the date (sends an error). I set both as "expression"
At the end, I changed the SQL statement directly in the .php page. I just have to remember to change it back every time I update the code in CCS.
|
|
|
|