Question
Need help - Get data from ResultSet
Dear all,
I'm kinda new into CFM. In fact, in another word, I got totally no experience on cfm.
I am now working on a project to troubleshoot the cfm page. The problem occur when :
1. User click on listing to action page
2. Action page throw exception on a variable is undefined in session.
I'd found the following code in the action page which look weird to me and it might cause the problem:
<CFQUERY NAME = "PROJ" DATASOURCE="#TESTSOURCE#>
Select PROJ.PRONAME from Project PROJ where PROJ.PROCODE = '1234'
</CFQUERY>
<CFSET session.PROJNAME = #PROJ.PRONAME#>
The exception throw is "Element PROJNAME is undefined in SESSION"
Appreciate for any fast reply. Thanks in advance!
I'm kinda new into CFM. In fact, in another word, I got totally no experience on cfm.
I am now working on a project to troubleshoot the cfm page. The problem occur when :
1. User click on listing to action page
2. Action page throw exception on a variable is undefined in session.
I'd found the following code in the action page which look weird to me and it might cause the problem:
<CFQUERY NAME = "PROJ" DATASOURCE="#TESTSOURCE#>
Select PROJ.PRONAME from Project PROJ where PROJ.PROCODE = '1234'
</CFQUERY>
<CFSET session.PROJNAME = #PROJ.PRONAME#>
The exception throw is "Element PROJNAME is undefined in SESSION"
Appreciate for any fast reply. Thanks in advance!
AdChoices