Database-related enhancements in ColdFusion 10

New Here ,
Sep 09, 2015 Sep 09, 2015

Copy link to clipboard

Copied

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

Views

270

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Sep 10, 2015 Sep 10, 2015

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Sep 10, 2015 Sep 10, 2015

Copy link to clipboard

Copied

 

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

 

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
Sep 10, 2015 Sep 10, 2015

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Sep 10, 2015 Sep 10, 2015

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Sep 10, 2015 Sep 10, 2015

Copy link to clipboard

Copied

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#">

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Sep 10, 2015 Sep 10, 2015

Copy link to clipboard

Copied

 

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Sep 16, 2015 Sep 16, 2015

Copy link to clipboard

Copied

LATEST

BKBK

Was the result posted what you were expecting?

thanks

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines