title: ColdFusion count the amount without using SQL
body: <p>I am trying to count the amount without using <code>SQL count()</code> code 
  Is there a way to extract the results including the number amount over ColdFusion?</p>
  
  <pre><code>Select test
  From ......
  Where .....
  
  
  &lt;Cfif not test.RecordCount&gt;
  No records found
  &lt;/Cfif&gt;
  &lt;cfoutput query="test"&gt;#amount#&lt;/cfoutput&gt;
  
  
  It should display like this
  TEST      CountOutput 
  TEST A:   22
  TEST B:   32
  TEST B:    1
  TEST C:   23
  </code></pre>