1 Reply Latest reply on Sep 17, 2015 12:36 AM by haxtbh

    [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'column_name'

    Namwam

      1. In my ColdFusion 11 website (with SQL Server 2008 R2), the following cfquery is throwing the above error:

       

      <cfquery name="deleteGrantModificationItems" datasource="#dsource#">

       

      DELETE col_key FROM myTable

       

      WHERE col_key = <cfqueryPARAM value = "#appkey#" CFSQLType = "CF_SQL_VARCHAR">

       

      </cfquery>

       

      2. When I run the sql profiler to capture the query, I get:

       

      eclare @p1 int

      et @p1=NULL

      exec sp_prepexec @p1 output,N'@P1 varchar(8000)',N'DELETE col_key FROM myTable

      WHERE col_key = @P1 ','000000001644'

      select @p1

       

       

       

      3. when I run the above in the Query Analyzer, I get the following error:

       

       

       

      Msg 208, Level 16, State 1, Line 1

       

      Invalid object name 'col_key'.

       

      Msg 8180, Level 16, State 1, Procedure sp_prepexec, Line 1

       

      Statement(s) could not be prepared.

       

      What could be the issue? Please help.