Error message on changing MSQL

[BadChough]

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" (then gives location of error,I suppose, although I don't recognize it) "TypeError: runtimeValue has no properties" - 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

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"));

 

[vacunita]

You say the update is occurring correctly which means its not a Mysql error.
I see no Javascript in the code you posted only what I can assume is PHP.

If the error is only within Dreamweaver, and its a javascript error, perhaps asking in the forum216, or the forum770 would probably produce a better result.



----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.