title: Exclude "deleted" rows when DELETED() is not supported
body: <p>I'm trying to work with some simple DBF files within ColdFusion. I've set up a System DSN in Windows using the dBase driver and have successfully set up the datasource in ColdFusion Administrator. I can do the usual SQL queries against the datasource with no issues.</p>
  
  <p>I've left the "show deleted rows" <strong>on</strong> in the DSN configuration. (The obvious answer is to change that setting, but for now let's pretend that I can't.)</p>
  
  <p>How, then, do I exclude rows marked as deleted in my queries? From information elsewhere, in FoxPro for instance, you'd use the <code>DELETED()</code> function to find those rows. However, if I use that function in my CF query I get</p>
  
  <blockquote>
    <p>[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC dBase Driver] Undefined function 'deleted' in expression. </p>
  </blockquote>
  
  <p>I've tried these two techniques:</p>
  
  <pre><code>SELECT ID, fName, lName, deleted() AS isDeleted
  FROM myTable
  
  SELECT ID, fName, lName
  FROM myTable
  WHERE NOT deleted('myTable')
  </code></pre>
  
  <p>Is there another way to do it that'll work with ColdFusion? Or is the driver setting my only hope?</p>