title: ColdFusion Conditional RecordCount
body: <p>Alright SO users... Here's a seemingly impossible to go wrong conditional statement. It is very simple, however, I cannot figure out why it won't work the way it is expected to.</p>
  
  <pre><code>&lt;cfoutput query="checkForAd"&gt;
          &lt;!--- also used the line &lt;cfif RecordCount eq 0&gt; ---&gt;
      &lt;cfif checkForAd.RecordCount eq 0&gt;
          &lt;!--- Display some message. (Perhaps using a table, undecided) ---&gt;
      &lt;cfelse&gt;
          &lt;!--- Display some other message. (Happens to be a table) ---&gt;
      &lt;/cfif&gt;
  &lt;/cfoutput&gt;
  </code></pre>
  
  <p>When the RecordCount returns a number greater than 0, the else case displays properly. When RecordCount returns 0, nothing is displayed and the form continues along its path. I've become very frustrated as this should be quite simple...</p>