1 Reply Latest reply on Aug 31, 2008 7:33 AM by Newsgroup_User

    Error message on changing MYSQL code

    smiffy47 Level 1
      I have managed to get my Update Record Server Behaviour to update the Timestamp on the MYSQL table. (And I'm chuffed)
      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
        • 1. Re: Error on changint MYSQL code
          Level 7
          Troubleshooting JavaScript errors in Dreamweaver
          http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_19105#dat

          Try #4

          --
          Murray --- ICQ 71997575
          Adobe Community Expert
          (If you *MUST* email me, don't LAUGH when you do so!)
          ==================
          http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
          http://www.dwfaq.com - DW FAQs, Tutorials & Resources
          ==================


          "smiffy47" <webforumsuser@macromedia.com> wrote in message
          news:g9avfr$2u9$1@forums.macromedia.com...
          >I have managed to get my Update Record Server Behaviour to update the
          >Timestamp
          > on the MYSQL table. (And I'm chuffed)
          > 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"));
          >