CF11 u18 issue
Hello, all,
While still hoping for a fix from u15, we have applied u18 to one of our servers in production and are now getting the following:
"Diagnostics: The ValueList() function has an invalid parameter: getarchiveyears.articleYears. Parameter 1 of function ValueList which is now getarchiveyears.articleYears must be pointing to a valid query name.
The error occurred on line 323."
Earlier in this document, we have:
<cfquery name="getarchiveyears" datasource="#application.newsdsn#" cachedwithin="#CreateTimeSpan(0,0,10,0)#">
SELECT
DISTINCT TO_CHAR(TitleDATE,'YYYY') articleYears
FROM
news_2016
WHERE
TO_CHAR(TitleDATE,'YYYY') > '2009'
ORDER BY
articleYears DESC
</cfquery>
So, there's a valid query, named (oddly enough) getarchiveyears.
The line triggering the error is:
<cfset newsyears = ValueList(getarchiveyears.articleYears,',') />
So, why is it now suddenly not seeing the valid query named getarchiveyears??? Again, if I remove the cache attribute, then it errs once in a few tries. But keeping the cache attribute, it errs EVERY TIME! wtf???
And as with the u15, if we roll it back it's never an issue. PLEASE FIX THIS! We have top brass breathing down our necks because we are three updates behind.
V/r,
^ _ ^
