[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>

Dynamically display all column data of a cfquery // get column value dynamically cfquery coldfusion //

Dynamically display all column data of a cfquery. 

this is useful when you don't know the name of columns of your cfquery result.


<cfloop query="Data">

       <cfloop list="#data.Columnlist#" index="local.Column" delimiters="," >

        <cfoutput>
              #Data[local.column][Data.currentrow]#
        </cfoutput>

</cfloop>
</cfloop>



Notes: 
1. data is query
2. data.columnlist is comma separted columnlist of a query

[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 80) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Coldfusion 

ErrorCode

1205

Deadlock Transaction because of cftransaction. 

Error is:
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 80) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 80) was deadlocked on lock resources with another process and has been chosen as the deadlock victim.



<cfquery name="qryGetLastID" datasource="#variables.Pub_DS#">
      SET NOCOUNT ON

      insert into table
      (column1,datecreated,createdby)
      values(1,2,3)

      SELECT @@Identity AS maxID
      SET NOCOUNT OF
</cfquery>