title: Cfinput checkbox checked
body: <p>I can't quite get this to work.</p>
  
  <p>My form has a number of inputs including one checkbox. In my <code>cfquery</code>, I just want to write some simple SQL content that tests to see if the checkbox is checked or not. But my code just ignores it completely. Here's the basics:</p>
  
  <pre><code>&lt;cfform name="form" action="...." format="HTML"&gt;
       ....
       &lt;cfinput type="checkbox" name="search_NR" id="search_NR" checked="no" /&gt;
      &lt;cfinput type="submit" name="submit"  value="Search" /&gt;
  &lt;/cfform&gt;
  </code></pre>
  
  <p>My <code>cfquery</code> is quite extensive, so I'll just put the part relevant to the checkbox here:</p>
  
  <pre><code>    &lt;cfif isDefined("form.search_NR")&gt;
          AND (tblMain.NR = true)
      &lt;/cfif&gt;
  </code></pre>
  
  <p>My thought was that the box wouldn't be defined if it wasn't checked. But whether or not I check the box on the form, the query just ignores this altogether. I just want to add <code>tblMain.NR = TRUE</code> to the rest of the SQL content when the box is checked.</p>