title: Passed value being treated as empty in CFQUERYPARAM
body: <p>This is baffling me greatly as I have done this a hundred times, but now it fails me. </p>
  
  <p>I am doing a basic query update using CF params, and the primary key for the table is passing an empty value in, resulting in a critical failure. </p>
  
  <p>Even if I enter a hardcoded number into the <code>#form.id placeholder#</code>, I get this:</p>
  
  <pre>
  Invalid data '' for CFSQLTYPE CF_SQL_NUMERIC.
  </pre>
  
  <p>Here is my code base</p>
  
  <pre class="lang-html prettyprint-override"><code>&lt;cfquery name="updateIdea" datasource="#request.db#"&gt;
              UPDATE freshideas
              SET subject = &lt;cfqueryparam cfsqltype="cf_sql_varchar" value="#form.subject#" null="no" /&gt;,
                  content = &lt;cfqueryparam cfsqltype="cf_sql_varchar" value="#form.content_text#" /&gt;,
                  postmonth = &lt;cfqueryparam cfsqltype="cf_sql_numeric" value="#form.postmonth#" /&gt;,
                  postyear = &lt;cfqueryparam cfsqltype="cf_sql_numeric" value="#form.postyear#" /&gt;,
                  imglink = &lt;cfqueryparam cfsqltype="cf_sql_varchar" value="#image#" /&gt;,
                  oindex = &lt;cfqueryparam cfsqltype="cf_sql_integer" value="#form.oindex#" null="no" maxlength="3" /&gt;
              WHERE id = &lt;cfqueryparam cfsqltype="cf_sql_integer" value="#form.id#" null="no" /&gt;
          &lt;/cfquery&gt;
  </code></pre>
  
  <p>The insert works fine, and the column ID is auto_increment int(5).</p>