title: CF9 Error Executing Database Query
body: <p>I am getting this error and don't understand why:</p>
  
  <blockquote>
    <p><strong>Error Executing Database Query</strong>. [Macromedia][SQLServer JDBC
    Driver][SQLServer]Invalid column name 'buildno'.   The error occurred
    in C:/data/wwwroot/webappsdev/cfeis/redbook/redbook_bio_load.cfm: line
    10</p>
  
  <pre><code>    8 :    select *
      9 :   from redbook_bio
      10 :       where build_num = '#session.build_num#'
      11 : &lt;/cfquery&gt;
      12 :
  </code></pre>
    
    <p>VENDORERRORCODE:    207<br> SQLSTATE:   42S22<br> SQL:       select * from
    redbook_bio where buildno = '4700'<br> DATASOURCE: xxxx<br>
    <strong><em>*</em>**<em>*</em>**</strong>"<br></p>
  </blockquote>
  
  <p>It is saying <code>buildno</code> is an invalid column name, but I do not have that name in my query. I used to, but changed both the column in the database and the column name in the query to build_num. You can see my exact code with line numbers, and that there is no 'buildno' in there. But looking at the SQL statement below that, it is still trying to use 'buildno'. </p>
  
  <p>I had my editor check the directory for anywhere it says <code>buildno</code> and no results came back. I have restarted the CF Service and cleared the cache. Why would it still be trying to run it with <code>buildno</code> instead of <code>build_num</code> like the code says?</p>