Hi,
I have got a table with one collumn called 'edittijd' (edit time). Every time an user changes a record, the field in the corresponding column gets the value of the current date and time. This can be done by building a custom page 'before edit'. Reason of this is that an user can see when the record has been updated. Code follows below.
function BeforeEdit(&$values, $where)
{
// Parameters:
// $values - Array object.
// Each field on the Edit form represented as 'Field name'-'Field value' pair
// $where - string with WHERE clause pointing to record to be edited
//********** Custom code ************
// put your custom code here
$values["Edittijd"]="now()";
return true;
// return true if you like to proceed with editing this record
// return false in other case
}
Problem is however that in 3.x versions of phprunner, I get the following error when I want to change the record.
'Record was not updated, Incorrect datetime value: 'now()' for column 'Edittijd' at row 1'
- I've tried it both using phprunner versions 4.4 and 5.0
- When removing the custom pages, everything works fine
- Edittijd has a 'datetime' type in mysql