Re: CF 9 running on MS-SQL 2008 breaks query

You may want to check the data type, when whomever updated the database may have defaulted the suite column to varchar or other text. > This simple query works fine on MS 2005 database but fails on an MS > 2008 server: > 1. First test: > > select suite from house_final_drawings where suite in

CF 9 running on MS-SQL 2008 breaks query

This simple query works fine on MS 2005 database but fails on an MS 2008 server: 1. First test: select suite from house_final_drawings where suite in (100,200) Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Conversion failed when converting the nvarchar value 'dd