title: How to INSERT an id number into a blank table in a database with Coldfusion
body: <p>I'm trying to insert data into a blank table. The data comes from a form that is submitted. The table is set up with an auto-increment PK. The problem is that when I insert the info, the table does not get anything put into it. The info from the form includes everything but the PK number. When I then add the number manually then it works as normal. This is what the code looks like:</p>
  
  <pre><code>&lt;cfquery name="updateInsOpTable" datasource="applewood"&gt;
  INSERT INTO ins_opt_table
  VALUES ('123 applewood road','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22')
  &lt;/cfquery&gt;
  </code></pre>
  
  <p>This throws an error because there is no PK. So how do I insert data into a table without a PK?</p>