DMXzone Database Updater PHP Support Product Page
Using NOW() for TIMESTAMP field
Asked 01 Apr 2016 12:36:00
1
has this question
01 Apr 2016 12:36:00 David Woolley posted:
I have 2 TIMESTAMP fields in my table: date_created & date_updatedMy Insert form has a hidden field for date_created
date_updated does not require a hidden field as it is set in phpmyadmin as 'onUpdate CURRENT_TIMESTAMP'
I need to set the value of the date_created field to NOW() but not sure how to do that.
If you put value="NOW()" , the quotes have to be stripped before processing.
I could do this by recoding the old Dreamweaver Insert Record Server Behavior, but need some advice about how to achieve this with the DB Updater Action Builder using Server Connect.