title: How to insert password as Hash to Ms SQL in coldfusion?
body: <p>I am creating a form that saves a user registration. I want to insert the password to the database as hash or md5.</p>
  
  <p>This is my html form with few coldfusion codes:</p>
  
  <pre><code>        &lt;form id="myForm" class="ui form segment" method="post" action="registeraction.cfm"&gt;
        &lt;p&gt;Let's go ahead and get you signed up.&lt;/p&gt;
  
        &lt;div class="field"&gt;
          &lt;div class="field"&gt;
          &lt;label&gt;Name&lt;/label&gt;
          &lt;input  placeholder="Name" name="name" type="text"&gt;
          &lt;/div&gt;
        &lt;/div&gt;
  
        &lt;div class="field"&gt;
          &lt;div class="field"&gt;
          &lt;label&gt;Email&lt;/label&gt;
          &lt;input  placeholder="Email" name="email" type="email"&gt;
          &lt;/div&gt;
        &lt;/div&gt;
  
        &lt;div class="field"&gt;
          &lt;div class="field"&gt;
          &lt;label&gt;Password&lt;/label&gt;
          &lt;input  placeholder="Password" name="password" type="password"&gt;
          &lt;/div&gt;
        &lt;/div&gt;
  
  
        &lt;input class="ui blue submit button" type="Submit" value="Submit"&gt;
      &lt;/form&gt;
  </code></pre>
  
  <p>This is the code in registeraction.cfm :</p>
  
  <pre><code>&lt;!--- Insert the new record ---&gt; 
  &lt;cfinsert datasource="mydatasource" tablename="Users"&gt; 
  
  &lt;h1&gt;User Added&lt;/h1&gt; 
  &lt;cfoutput&gt; You have added #Form.name# #Form.email# to the testdb database. 
  &lt;/cfoutput&gt; 
  </code></pre>