title: Get count of specifc rows returned in cfquery
body: <p>I know you can get the count of how many items are returned in your query but...
  Question: Is it possible to get a <code>recordcount</code> of rows with a specific value for example...</p>
  
  <pre><code>&lt;cfset totalReturned = myquery.recordcount&gt;
  
  &lt;cfset totalReturnedComplete = myquery.recordcount (where status = "Complete")&gt;
  </code></pre>
  
  <p>I know the above will not work but I am looking for something like the above code. </p>