ChronoEngine.com homepage

Forums

Please write a review for the extension you are using on the Joomla extensions directory before posting a new question as we are being spammed by many negative reviews.

Thank you for your support!

Filter settings: now()

neotrend 17 Apr, 2018
I read items from my table and I have a value called publish_down. I now want to have the filtering setting, that only the items before the publish_down value are returned.
In function Read Data, I have inserted in the Where conditions:
 Article.publish_down/>=:now()

it doesn't work because the sql statement looks like:
 WHERE `Article`.`publish_down` >= 'now()'

and I need it without '', means the output should be like:
 WHERE `Article`.`publish_down` >= now()
Thank you for help.
Max_admin 19 Apr, 2018
Answer
Hello neotrend,

Please try:
Article.publish_down/>=:{date:Y-m-d H:i:s}
Best regards
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
This topic is locked and no more replies can be posted.

2Checkout.com

2CheckOut.com Inc. (Ohio, USA) is an authorized retailer for goods and services provided by ChronoEngine.com