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

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