title: how can i store 64 bit string in integer column?
body: <p>I have one column wherein I am converting domain_name to 64 bit bigint string.</p>
  
  <p>it successfully converting it.</p>
  
  <pre><code>CONV(SUBSTRING(CAST(SHA(TRIM("#arguments.domain_name#")) AS CHAR), 1, 16), 16, 10),
  </code></pre>
  
  <p>I want use this converted string in another table and trying to store it as Integer. when i have tried casting it like this</p>
  
  <pre><code>CAST(arguments.siteid AS INT(11) AS INTEGER)
  </code></pre>
  
  <p>got error; You have an SQL syntax error.</p>
  
  <p>I have tried to store it in another way like</p>
  
  <pre><code>&lt;cfqueryparam value="#arguments.siteid#" cfsqltype="cf_sql_integer" /&gt;
  </code></pre>
  
  <p>it is storing something else like <code>2147483647</code> though the siteid is <code>14177909183865716377</code>.
  can anyone help me how to cast it ?</p>