title: How to use ASP variables in SQL statement
body: <pre class="lang-vbs prettyprint-override"><code>&lt;%
  postit = request.querystring("thispost")
  response.write(postit)
  %&gt; 
  </code></pre>
  
  <p><code>postit</code> is the variable. The <code>response.write</code> works and this is all above the SQL statement below.</p>
  
  <p>This is the SQL however when I add the <code>postit</code> variable I get this error message:</p>
  
  <pre class="lang-vb prettyprint-override"><code>delCmd.CommandText="DELETE * FROM post WHERE (pos_ID = postit )"
  </code></pre>
  
  <pre class="lang-none prettyprint-override"><code>Microsoft Access Database Engine error '80040e10'
  No value given for one or more required parameters. 
  /student/s0190204/wip/deleterecord.asp, line 32
  </code></pre>