BlakeSeven
|
Posted: 02/18/2004, 2:36 PM |
|
Sometimes you may find it better to use the MySQL now() function to get your datetime stamp, than using the CCS code generated timestamp.
I was eventually able to find the answer in the CCS documentation under the heading, Dynamically Modify the SQL Statement.
I was able to use the example there to do the same with an Insert statement using Before Execute Insert, and placing in this custom code.
//Custom Code @59-5F6DD002
// -------------------------
global $builds;
$builds->ds->SQL = str_replace("INSERT INTO builds (", "INSERT INTO builds (bld_recorddatetime, ", $builds->ds->SQL);
$builds->ds->SQL = str_replace(") VALUES (", ") VALUES (now(), ", $builds->ds->SQL);
// -------------------------
//End Custom Code
|
|
|
|