In DreamweaverMX2004 I have managed to get my Update Record Server Behaviour to update the Timestamp on a MYSQL table.
However the way I have done it results in the error "Whilst executing analyzeServerBehaviour in UpdateRecord.htm the following JavaScript error occured: At line 395 of file:
- not on the browser which performs fine, but within DWmx2004. Can someone tell me how to overcome the error message, or should I just ignore it as the code does the job?
The change that produced this error message was to add the "ck_timestmp=NOW()" element in the following code
However the way I have done it results in the error "Whilst executing analyzeServerBehaviour in UpdateRecord.htm the following JavaScript error occured: At line 395 of file:
Code:
C:\Program Files\Macromedia\Dreamweaver MX 2004\Configuration\Server Models\PHP_MYSQL\dwscriptsServerImpl.js": TypeError: runtimeValue has no properties
The change that produced this error message was to add the "ck_timestmp=NOW()" element in the following code
Code:
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
$updateSQL = sprintf("UPDATE chk_sixmonth SET ck_manager=%s, ck_firstname=%s, ck_lastname=%s, ck_position=%s, ck_tel=%s, ck_email=%s, ck_their_notes=%s, ck_timestmp=NOW() WHERE ck_pk=%s",
GetSQLValueString($_POST['ck_manager'], "text"),
GetSQLValueString($_POST['ck_firstname'], "text"),
GetSQLValueString($_POST['ck_lastname'], "text"),
GetSQLValueString($_POST['ck_position'], "text"),
GetSQLValueString($_POST['ck_tel'], "text"),
GetSQLValueString($_POST['ck_email'], "text"),
GetSQLValueString($_POST['ck_their_notes'], "text"),
GetSQLValueString($_POST['ck_pk'], "int"));