title: Double quote not working in cfquery after upgrading from ColdFusion 9 to 2018
body: <p>In ColdFusion 9, the following cfquery worked:</p>
  
  <pre><code>&lt;cfquery&gt;
      SELECT someField 
      FROM    someTable 
      WHERE   IPADDRESS = "#CGI.REMOTE_ADDR#"
  &lt;/cfquery&gt;
  </code></pre>
  
  <p>After upgrading to ColdFusion 2018, the query no longer works. However, it does work if I replace the double quotes with single quotes; i.e., <code>'#CGI.REMOTE_ADDR#'</code> or <code>'CGI.REMOTE_ADDR'</code> Did something change in newer versions of ColdFusion?</p>