Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error message on changing MSQL

Status
Not open for further replies.

BadChough

Programmer
Dec 20, 2007
137
GB
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:
Code:
 C:\Program Files\Macromedia\Dreamweaver MX 2004\Configuration\Server Models\PHP_MYSQL\dwscriptsServerImpl.js": 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
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"));
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top