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

 [Macromedia][SQLServer JDBC Driver][SQLServer]The multi-part identifier "local.QryVatCode.VatCode_id" could not be bound.



this will come when you dont use ## signs inside in cfquery for any dynamic variable execution,


think if you are doing something like this.


<cfquery>
insert table1 (col1)
values (val1)
</cfquery>


if val1 is a coldfusion variable, then you have to do #val1#


<cfquery>
insert table1 (col1)
values (#val1#)
</cfquery>