title: How can I assign a null value to a query param in ColdFusion?
body: <p>I have a database table with an int column that can also be null. Adding an int to the column is fine, but setting it back to null causes an error. Since ColdFusion does not support null values, I usually pass the value as an empty string:</p>
  
  <pre><code>local.myParam = "";
  </code></pre>
  
  <p>This causes an error however, that <code>""</code> is not of type numeric.</p>
  
  <pre><code>post.addParam(name="parentId", cfsqltype="CF_SQL_INTEGER", value=arguments.parentId);
  </code></pre>
  
  <p>Any ideas how I can work around this limitation?</p>