Database-related enhancements in ColdFusion 10

[Malcolm_Zognrah_557]

Anyone use this feature on coldfusion administrator yet? I tried to follow the following link Database-related enhancements in ColdFusion 10 - ColdFusion, English documentation - Adobe Learning ...

but I have no luck getting it to work with Microsoft Sql Server 2008 R2

[BKBK]

You call it "this feature", but it's about a number of enhancements. Could you show us the code that you used.

[Malcolm_Zognrah_557]

<cfscript>

    clientInfo = structNew();

    clientInfo.AccountingInfo = "MyAccount_cfquery";

    clientInfo.Action = "cfstoredproc_cfquery";

    clientInfo.ApplicationName = "testApp_cfquery";

    clientInfo.ClientHostName = "Testserver_cfquery";

    clientInfo.ClientID = "testID_cfquery";

    clientInfo.ClientUser = "cfadmin_cfquery";

    clientInfo.ProgramID = 1234;

    clientInfo.Module = "test_query";

</cfscript>

<cfquery name="qName"  datasource="#regdatasource#" clientInfo="#clientInfo#">

Select * from employees

</cfquery>

[haxtbh]

What happens when you run it? What are you expecting to happen??

[Malcolm_Zognrah_557]

It run fine without an error but the application name field is not being filled in sql server

[BKBK]

Do you see the applicationname attribute when you run this code:

<cfscript>

    clientInfo = structNew();

    clientInfo.AccountingInfo = "MyAccount_cfquery";

    clientInfo.Action = "cfstoredproc_cfquery";

    clientInfo.ApplicationName = "testApp_cfquery";

    clientInfo.ClientHostName = "Testserver_cfquery";

    clientInfo.ClientID = "testID_cfquery";

    clientInfo.ClientUser = "cfadmin_cfquery";

    clientInfo.ProgramID = 1234;

    clientInfo.Module = "test_query";

</cfscript>

<cfquery name="qName"  datasource="#regdatasource#" clientInfo="#clientInfo#">

     Select * from employees

</cfquery>

<cfquery fetchclientinfo="true" result="res" datasource="#regdatasource#">

    Select * from employees

</cfquery>

<cfdump var="#res#">

[Malcolm_Zognrah_557]

struct
CACHED	false
CLIENTINFO	struct AccountingInfo MyAccount_cfquery ApplicationName testApp_cfquery ClientHostName Testserver_cfquery ClientUser cfadmin_cfquery ProgramID 1234
COLUMNLIST	*****
EXECUTIONTIME	1580
RECORDCOUNT	462
SQL	Select * from employees

  result of the dump

[Malcolm_Zognrah_557]

BKBK‌

Was the result posted what you were expecting?

thanks