Status/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): Samson Gonzalez / Samson Gonzalez (Samson Gonzalez)
Created: 07/27/2016
Components: Database
Versions: 2016
Failure Type: Non Functioning
Found In Build/Fixed In Build: CF2016_Update2 /
Priority/Frequency: Critical / All users will encounter
Locale/System: English / Linux RHEL 6.4
Vote Count: 0
Problem Description: CFLOOP does not work with a stored procedure result that's in the local scope.
I get the error:
The value of the attribute query, which is currently local.getStyleLocalization, is invalid.
Steps to Reproduce: Using a stored procedure that returns 3 resultsets. All of them are named under a local scope variable.
e.g.
<cfstoredproc procedure="get_model_info" returncode="no" datasource="#arguments.dsn#" cachedwithin="#CreateTimeSpan(0,0,0,30)#">
<cfprocparam value="#arguments.model#" cfsqltype="CF_SQL_NUMERIC">
<cfprocresult name="local.getModelInfo" resultset="1">
<cfprocresult name="local.getStyleSizes" resultset="2">
<cfprocresult name="local.getStyleLocalization" resultset="3">
</cfstoredproc>
Local scope query works for cfoutput tags.
<cfoutput query="local.getModelInfo">
but fails on cfloop tag
<cfloop query="local.getStyleLocalization">
This works under cf9 and cf11, but not cf2016.
Actual Result:
Attribute validation error for tag cfloop.
The value of the attribute query, which is currently local.getStyleLocalization, is invalid.
Expected Result:
Loop over resultset.
Any Workarounds:
None yet.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 4176225
External Customer Info:
External Company:
External Customer Name: Samson Gonzalez
External Customer Email:
External Test Config: My Hardware and Environment details:
OS: 3.10.0-327.22.2.el7.x86_64
CF: Version 2016,0,02,299200
JDK:1.8.0_92
DB: Sybase 15
JDBC: com.sybase.jdbc3.jdbc.SybDriverAttachments:
Comments: