Skip to main content
September 16, 2015
Question

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

  • September 16, 2015
  • 1 reply
  • 908 views

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 @7246612 int

et @7246612=NULL

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

WHERE col_key = @7246612 ','000000001644'

select @7246612

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.

This topic has been closed for replies.

1 reply

Inspiring
September 17, 2015

Your SQL is incorrect.

The statement should just be

DELETE FROM myTable

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