tracker issue : CF-4147522

select a category, or use search below
(searches all categories and all time range)

Caching Not Working with QueryExecute

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/Duplicate

Reporter/Name(from Bugbase): Giancarlo Gomez / Giancarlo Gomez (Giancarlo Gomez)

Created: 05/02/2016

Components: Database

Versions: 11.0

Failure Type:

Found In Build/Fixed In Build: CF11_Final /

Priority/Frequency: Major / All users will encounter

Locale/System: English / Win 2012 Server x64

Vote Count: 1

Duplicate ID:	CF-4087462

Problem Description: Caching Not Working with QueryExecute

Steps to Reproduce: Test with the following code, set your own SQL string.

<cfset sqlString = "SELECT TOP 5 productID FROM products" />
<cfquery name="q1" cachedWithin="#createTimeSpan(0, 1, 0, 0)#">
            { cachedWithin :createTimeSpan(0, 1, 0, 0), name: "q2"}
        new Query(
            sql             : sqlString,
            cachedWithin    : createTimeSpan(0, 1, 0, 0),
            name            : "q3"

Actual Result: q2 is never cached

Expected Result: q2 to be cached

Any Workarounds: don't use QueryExecute

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	4147522

External Customer Info:
External Company:  
External Customer Name: Giancarlo Gomez
External Customer Email:



Please ignore this, apparently there is already a bug entered with a fix hopefully going out soon.
Comment by External U.
2967 | May 02, 2016 09:47:39 PM GMT
Giancarlo, Yes, this is a duplicate of bug #CF-4087462. So, I am withdrawing this as duplicate.
Comment by Nimit S.
2968 | May 03, 2016 01:31:48 AM GMT