Highlighted

Database-related enhancements in ColdFusion 10

New Here ,
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

263

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

Database-related enhancements in ColdFusion 10

New Here ,
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

264

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
Sep 09, 2015 0
Adobe Community Professional ,
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
Reply
Loading...
Sep 10, 2015 0
New Here ,
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
Reply
Loading...
Sep 10, 2015 0
Advocate ,
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
Reply
Loading...
Sep 10, 2015 0
New Here ,
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
Reply
Loading...
Sep 10, 2015 0
Adobe Community Professional ,
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
Reply
Loading...
Sep 10, 2015 0
New Here ,
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
Reply
Loading...
Sep 10, 2015 0
New Here ,
Sep 16, 2015

Copy link to clipboard

Copied

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
Reply
Loading...
Sep 16, 2015 0