Dates coming up blank when inserting new records

3 posts by 2 authors in: Forums > CMS Builder
Last Post: January 23, 2019   (RSS)

By daniel - January 23, 2019

Hi Jerry,

When setting up your $colsToValues array, if you want to use a MySQL function like "NOW()", the field name needs to be appended with "=" like this:

$colsToValues['createdDate='] = 'NOW()';

Let me know if this fixes the issue, or if you have any other questions!

Thanks,

Daniel
Technical Lead
interactivetools.com

By gkornbluth - January 23, 2019

Hi Daniel,

It's so easy when you know how...

Thanks for the solution.

Best,

Jerry Kornbluth

The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php