How to use "SESSION_kt_email" in my CFC..?

Report · Dec 21, 2012

Can someone show me the correct way to reference a Session variable called "SESSION.kt_email" and filter it out of my User_email list?

- The CFC below is used to grab all of the correct emails, but "exclude" the email of the logged in user

- I'm using the GROUP_CONCAT so the outputted emails are separated by commas

- My CFC works fine until I add in the Session stuff, then I get this error..

Here is the CFC email_actions_updated.cfc:

-----------------------------------------------

SELECT GROUP_CONCAT(NULLIF(User_email, <cfqueryparam cfsqltype="cf_sql_varchar" value="#ARGUMENTS.kt_email#"> )) AS User_email

FROM (

SELECT CONCAT(tblemailaction.uea_User, "@corp.clearwave.com") AS User_email,

tblemailaction.uea_ADSL

FROM tblemailaction, tbltickets, tbltickettype

WHERE tbltickets.ttType = tbltickettype.ttDesc

AND tbltickettype.ttID = tblemailaction.uea_ADSL

AND tblemailaction.uea_Updated = 1

AND ttNum = <cfqueryparam cfsqltype="cf_sql_integer" value="#ARGUMENTS.id#">

) q

</cfquery>

</cffunction>

</cfcomponent>

-----------------------------------------------

Here is my sample calling page:

------------------------------------------------

<cfinvoke

component="CRM.CTS.email_actions_updated"

method="GetEmails"

returnvariable="rsEmailAction"

id="#URL.id#">

<head>

</head>

<body>

<input name="email_list" type="text" id="email_list" value="<cfoutput>#rsEmailAction.User_email#</cfoutput>" size="150" />

</body>

---------------------------------------------

Report · Dec 22, 2012

<cffunction name="GetEmails" access="remote" returnType="any" output="false">
    <cfargument name="id" type="numeric" required="true">
    <cfargument name="kt_email" type="any" required="true">
...
...
<cfinvoke
    component="CRM.CTS.email_actions_updated"
    method="GetEmails"
    returnvariable="rsEmailAction"
    id="#URL.id#">

Your function requires 2 arguments. Yet your cfinvoke has just one. Were you perhaps going for something like this:

<cfinvoke

component="CRM.CTS.email_actions_updated"

method="GetEmails"

returnvariable="rsEmailAction"

id="#URL.id#"

kt_email="#session.kt_email#">

Report · Dec 26, 2012

I added in the second argument as follows:

------------------------------------------------

<cfinvoke

component="CRM.CTS.email_actions_updated"

method="GetEmails"

returnvariable="rsEmailAction"

id="#URL.id#"

kt_email="#session.kt_email#">

And now I'm getting an error on the cfc:

---------------------------------------------

Element SESSION.KT_EMAIL is undefined in ARGUMENTS.

Report · Dec 26, 2012

Is the cfc code still the same as in the opening post? In any event, if you comment out all the code in your function and replace it with <cfdump var="#arguments#">, do you see the two arguments and their expected values?

Report · Dec 26, 2012

Dan, that helped to point to the problem and the error on my cfc.. I had indeed changed the cfc since my first post and inserted the word "Session" to my Argument as below..

SELECT GROUP_CONCAT(NULLIF(User_email, <cfqueryparam cfsqltype="cf_sql_varchar" value="#ARGUMENTS.Session.kt_email#"> )) AS User_email

I changed the #ARGUMENTS.Session.kt_email# to just #ARGUMENTS.kt_email# and it now returns the correct results!

Thanks to both you and BKBK

ps: you must live in these forums..?

Report · Dec 22, 2012

In addition to BKBK's answer, are you sure about the double quotes in the concat function of your query?

Adobe Community

How to use "SESSION_kt_email" in my CFC..?

1 Correct answer

Element SESSION.KT_EMAIL is undefined in ARGUMENTS.