title: corona lua sql update statement correct syntax when using variables
body: <p>This may seem very basic but I cannot find correct syntax when using a variable.</p>
  
  <p>This works:</p>
  
  <pre><code>local updateTable = [[UPDATE userDetails SET month_id = 100 WHERE id=1]]
  
  db:exec( updateTable)
  </code></pre>
  
  <p>the below doesn't:</p>
  
  <pre><code>local myVariable = 100
  
  local updateTable = [[UPDATE userDetails SET month_id = myVariable WHERE id=1]]
  
  db:exec( updateTable)
  </code></pre>