8
Replies
Wow, jumping in on a Satruday. Thanks @BKBK !
Good catch, you are correct that the application of a cache appears to be the pivoting factor in this example's error.
However, I'm not sure the time span of the cache is the issue. I've created a simplified standalone example which employs a full one day cache - and the error is still present, even when employing the "does it exist?" test first.
Here is the "broken" version:
<cfstoredproc procedure="Get_Centers" datasource="[redacted]" cachedwithin="#createTimespan(1,0,0,0)#">
<cfprocparam variable="IdClient" cfsqltype="CF_SQL_INTEGER" value="2" />
<cfprocresult name="qResults" />
</cfstoredProc>
<cfdump var="#qResults#" />
<hr/>
<cfdump var="#qResults.columnList#" />
<hr/>
<cfdump var="#queryKeyExists(qResults, "ADDED_IDUSERS")#" />
<hr/>
<cfif queryKeyExists(qResults, "ADDED_IDUSERS")>
<cfset queryDeleteColumn(qResults,'ADDED_IDUSERS') />
</cfif>
<hr/>
<cfdump var="#qResults.columnList#" />Which produces this:
Next, here is the "fixed" version:
<cfstoredproc procedure="Get_Centers" datasource="[redacted]" cachedwithin="#createTimespan(1,0,0,0)#">
<cfprocparam variable="IdClient" cfsqltype="CF_SQL_INTEGER" value="2" />
<cfprocresult name="qResults" />
</cfstoredProc>
<!--- ADDED --->
<cfquery name="qResults" dbtype="query">
SELECT * FROM qResults
</cfquery>
<cfdump var="#qResults#" />
<hr/>
<cfdump var="#qResults.columnList#" />
<hr/>
<cfdump var="#queryKeyExists(qResults, "ADDED_IDUSERS")#" />
<hr/>
<cfif queryKeyExists(qResults, "ADDED_IDUSERS")>
<cfset queryDeleteColumn(qResults,'ADDED_IDUSERS') />
</cfif>
<hr/>
<cfdump var="#qResults.columnList#" />Here's the error-free result, after the ADDED interim step "turn this query into a query" step
So to me, it seems a bit buggy. The application of the cache seems to affect some internal column array, no matter how long the life span of the cache. The queryKeyExists function considers the column extant, while the queryDeleteColumn disagrees, perhaps using a different test.
Can you audit my logic? Thanks again.
AdChoices