ColdFusion does not recognize new MSSQL table column

Hello.  When we add a new column into our SQL tables and run a select, insert, etc. query, ColdFusion does not recognize the newly added column and gives us an error saying the column does not exist.  Is there a setting in the administrator we need to turn on or off?  We tried caching the query at 0 seconds and changing the application name, which didn't work.  We are using ColdFusion 9 and MSSQL Server 2008.  Thanks!
varimerewebAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
gdemariaConnect With a Mentor Commented:
If it's cached, you can change the query for a quick test by adding something meaningless like

  "AND 1=1"  

 to the where clause

Restarting the service will also work

or just waiting X number of minutes...


0
All Courses

From novice to tech pro — start learning today.