title: MySQL query returning false, but executing correctly
body: <p>I am working out of Google Apps Script and connecting to an external database using JDBC. </p>
  
  <p>I have a user table and a contracts table, I have changed some of the values for privacy but this is my basic query. Basically I have a list of contract numbers that I want to loop over, and for each one, execute the query. The contracts table and the user table share a primary id, so I am just trying to update a value in the user table, where the users contract id equals the contract id of that contract number.</p>
  
  <pre><code>var contractNumbers = ["123","456","789"];
  for (var a in contractNumbers) {
    var stmt = conn.createStatement();  
    var contractNum = contractNumbers[a];
    var query = "UPDATE user INNER JOIN contracts ON user.id_c = contracts.id SET user.quantity = '1' WHERE contracts.number = '" + contractNum + "'";
    var stmt = conn.prepareStatement(query);
    var result = stmt.execute();
  }
  </code></pre>
  
  <p>This query is working and is changing the value correctly and accurately, however the result always returns false. Any idea what may be wrong with my query that it is working, but returning false? Or maybe a suggestion for a better way to execute this query?</p>