The multi-part identifier "variable" could not be bound.

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]The multi-part identifier "my.variable.name" could not be bound.

This error means that you did not surround your variable(s) with pound signs (hash marks) in your query.

view plain print about
1<cfquery name="getData" >
2    SELECT     [ID],
3         [Value],
4         [Identifier],
5         [Identifier_id]
6    FROM     [MASTER_PLANNING]
7    WHERE    0 = 0
8        <cfif StructKeyExists(arguments, "ID")>
9            AND ID = arguments.ID
10        </cfif>
11        <cfif StructKeyExists(arguments, "Value")>
12            AND [Value] = arguments.Value
13        </cfif>
14        <cfif StructKeyExists(arguments, "Identifier")>
15            AND Identifier = arguments.Identifier
16        </cfif>
17        <cfif StructKeyExists(arguments, "Identifier_id")>
18            AND Identifier_id = arguments.Identifier_id
19        </cfif>
20</cfquery>

Should look like:

view plain print about
1<cfquery name="getData>
2    SELECT     [ID],
3         [Value],
4         [Identifier],
5         [Identifier_id]
6    FROM     [MASTER_PLANNING]
7    WHERE    0 = 0
8        <cfif StructKeyExists(arguments, "
ID")>
9            AND ID = #arguments.ID#
10        </cfif>
11        <cfif StructKeyExists(arguments, "
Value")>
12            AND [Value] = #arguments.Value#
13        </cfif>
14        <cfif StructKeyExists(arguments, "
Identifier")>
15            AND Identifier = #arguments.Identifier#
16        </cfif>
17        <cfif StructKeyExists(arguments, "
Identifier_id")>
18            AND Identifier_id = #arguments.Identifier_id#
19        </cfif>
20</cfquery>

Comments (Comment Moderation is enabled. Your comment will not appear until approved.)
BlogCFC was created by Raymond Camden. This blog is running version 5.9.7. Contact Blog Owner