title: Why is ColdFusion changing my values when I use <cfqueryparam>?
body: <p>I am using ColdFusion 9.0.1 and SQL Server 2005.</p>
  
  <p>The column in my database is name Points. It is set up as numeric(6,1).</p>
  
  <p>When I write a query in SQL Server Management Studio to drop in values like 1.2 or 5.5, the numbers store correctly.  When I drop in 1.23 it rounds to 1.2. When I drop in 5.55, it rounds to 5.6.  This is exactly what I expect.</p>
  
  <pre><code>UPDATE TableName
  SET Points = 1.2
  </code></pre>
  
  <p>When I pass my values to the CFC and DO NOT use CFQUERYPARAM, I get the exact results as described above.</p>
  
  <p>When I pass my values to the CFC uses CFQUERYPARAM, I do not get what I expect. When I drop in a number like 1.2 or 5.5, the value gets rounded to 1.0 or 6.0.</p>
  
  <pre><code>UPDATE TableName
  SET Points = &lt;cfqueryparam type="CF_SQL_DECIMAL" value="#Points#"&gt;
  </code></pre>
  
  <p>I have changed the CFSQLTYPE to CF_SQL_NUMERIC and CF_SQL_DECIMAL.  Still, I cannot get the numbers to save correctly.</p>
  
  <p>When I run the query below in my CFC, the number gets stored as 1.0.</p>
  
  <pre><code>UPDATE TableName
  SET Points = &lt;cfqueryparam type="CF_SQL_DECIMAL" value="1.23"&gt;
  </code></pre>
  
  <p>Can you help me figure out why this isn't behaving as I expect it to?</p>