Answered
Parsing query variable
I am facing a problem while parsing query output variable.
Scenario:-
I have stored session variable name as the column value of a table.
Now I have used cfquery tag and get the result column value which is the session variable name. But cold fusion didn't parse that session variable with its actual value.
Step1- Table view by using cfdump tag
query - Top 1 of 1 Rows
PARAMETERNAME - PARAMETERVALUE
1 @matterspacename - #SESSION.Matter_space_Name#
Step2- Using cfquery tag to fetch data from table:-
<cfquery name="qSendNotification" datasource="#Database_DSN#">
select
ParameterName,
ParameterValue
from
Tbl_EventParameterDetails
where
NotificationEventID = 1
and IsActive = 1
</cfquery>
Step3- Now using result of cfquery output.
<cfset event_data= #qSendNotification.ParameterValue#>
Step4- When I used cfdump to display result value its shows as under:-
<cfdump var="#event_data#">
output:- #SESSION.Matter_space_Name#
Instead of parsing actual value of the session variable it displays the session variable name.
Please help me, How to parse this session value or if my code has some error, please suggest me any other way to handle this situation.
Thanks in advance
Scenario:-
I have stored session variable name as the column value of a table.
Now I have used cfquery tag and get the result column value which is the session variable name. But cold fusion didn't parse that session variable with its actual value.
Step1- Table view by using cfdump tag
query - Top 1 of 1 Rows
PARAMETERNAME - PARAMETERVALUE
1 @matterspacename - #SESSION.Matter_space_Name#
Step2- Using cfquery tag to fetch data from table:-
<cfquery name="qSendNotification" datasource="#Database_DSN#">
select
ParameterName,
ParameterValue
from
Tbl_EventParameterDetails
where
NotificationEventID = 1
and IsActive = 1
</cfquery>
Step3- Now using result of cfquery output.
<cfset event_data= #qSendNotification.ParameterValue#>
Step4- When I used cfdump to display result value its shows as under:-
<cfdump var="#event_data#">
output:- #SESSION.Matter_space_Name#
Instead of parsing actual value of the session variable it displays the session variable name.
Please help me, How to parse this session value or if my code has some error, please suggest me any other way to handle this situation.
Thanks in advance
