<div>
<div class="content wysiwyg-content">
Hello. &nbsp;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. &nbsp;Is there a setting in the administrator we need to turn on or off? &nbsp;We tried caching the query at 0 seconds and changing the application name, which didn't work. &nbsp;We are using ColdFusion 9 and MSSQL Server 2008. &nbsp;Thanks!
</div>
</div>


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!

ColdFusion does not recognize new MSSQL table column

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.

ColdFusion Language

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.