title: INSERT INTO statement contains following unknown field name
body: <p>I’m using Coldfusion 9,0,0,251028 on Windows 7 64-bit, with a Microsoft Access 97 database.</p>
  
  <p>When I run this query:</p>
  
  <pre><code>&lt;cfquery name="put_in_info" datasource="#db#"&gt;
  
        insert into news
  
                    (is_current, display, mes_dat,mes_tim,mes_sub,mes_text,scrollshow,exp_dat)
  
        values
  
    (1,1, #createodbcdate(now())#, #createodbctime(now())#, '#subject#', '#message#',1, #session.expdate#)
  
  &lt;/cfquery&gt;
  </code></pre>
  
  <p>I get this error:</p>
  
  <pre><code>Error Executing Database Query.
  
  [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement contains the following unknown field name: 'exp_dat'. Make sure you have typed the name correctly, and try the operation again.   The error occurred in H:\Inetpub\pvalert.com\listserver\admin\templates\post_breaking.cfm: line 26
  Called from H:\Inetpub\pvalert.com\listserver\admin\new_process.cfm: line 54
  Called from H:\Inetpub\pvalert.com\listserver\admin\templates\post_breaking.cfm: line 26
  Called from H:\Inetpub\pvalert.com\listserver\admin\new_process.cfm: line 54
  
  24 :      (is_current, display, mes_dat,mes_tim,mes_sub,mes_text,scrollshow,exp_dat)
  
  25 :   values
  
  26 :   (1,1, #createodbcdate(now())#, #createodbctime(now())#, '#subject#', '#message#',1, #session.expdate#)
  
  27 :    &lt;/cfquery&gt;
  
  28 :
  
  VENDORERRORCODE
  
  
    -1507
  
  SQLSTATE
  
  
    HYS22
  
  SQL
  
  
     insert into news (is_current, display, mes_dat,mes_tim,mes_sub,mes_text,scrollshow,exp_dat) values (1,1, {d '2011-04-11'}, {t '17:49:09'}, 'Test message - please ignore', 'This is a test message, please ignore. ',1, {ts '2011-05-15 00:00:00'})
  
  DATASOURCE
  
  
    rpv_list
  </code></pre>
  
  <p>Exp_dat is an expiration date column in a table that I need to update.</p>
  
  <p>I've tried removing the "session." on the expdate variable, and that did nothing.  Likewise for removing the any spaces around line 24's "exp_dat".</p>