1 Reply Latest reply on Jun 11, 2013 8:39 AM by Reed Powell

    INFORMATION_SCHEMA.Columns

    happyjeff

      i have the following query that worked just fine on CF7 and SQL server 2000

       

      <cfquery name="getColumns" datasource="ds">

      SELECT Column_Name, Data_Type

      FROM INFORMATION_SCHEMA.Columns

      WHERE Table_Name = 'Fields'

      AND Table_Catalog = 'databasename'

      </cfquery>

       

      now that have upgraded to CF 9 and SQL 2012 - this query does not work

      "

      Error Executing Database Query.

      [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'FROM'.

       

       

       

      Any ideas - trying to export from SQL database to an excel file - THANKS!