tracker issue : CF-4198309

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

CFSCRIPT QoQ issue (when querying object created via 'queryNew')

| View in Tracker

Status/Resolution/Reason: Closed/Won't Fix/NeedMoreInfo

Reporter/Name(from Bugbase): Jack Drysdale Jr / Jack Drysdale Jr ()

Created: 02/02/2017

Components: Language, Functions

Versions: 2016,11.0,10.0

Failure Type: Non Functioning

Found In Build/Fixed In Build: 10,0,20,299202 /

Priority/Frequency: Normal / Unknown

Locale/System: English / Win 2012 Server x64

Vote Count: 1

Problem Description:  Query object created in CFSCRIPT with queryNew() cannot be queried inside CFSCRIPT.  You can QoQ _after_ the closing </CFSCRIPT> tag, but not inside the CFSCRIPT.

Steps to Reproduce:  Description of issue on Adobe Forums at: https://forums.adobe.com/thread/2272356

Actual Result:  Various error messages ("Datasource '' cannot be found"; "QoQ runtime issue"; "Table 'cities' cannot be found.")

Expected Result:  A QoQ object that can be displayed.

Any Workarounds:  Not inside CFSCRIPT.  You can place a QoQ outside (after) the CFSCRIPT tag, but that's the only way that I've (so far) been able to get it to work.

Attachments:

Comments:

I can confirm that this scenario fails in CF11,0,11,301867
Comment by Eddie L.
1247 | February 02, 2017 08:33:03 PM GMT
NeedMoreInfo??? Open CFSCRIPT tag. Write code using queryNew() to create a query object; fill it with data. Try QoQ before the closing CFSCRIPT tag. Hint: It will fail. Close CFSCRIPT tag. After the closing CFSCRIPT tag, run a QoQ against query object. It works. Between this and the inability of Adobe to fix the "edit" feature of Solr collections, I have lost faith in Adobe.
Comment by Jack D.
1248 | October 18, 2017 05:00:10 PM GMT
Apparently this has been fixed in CF11. But it was not working in CF10. Hopefully, this can still be fixed for CF10.
Comment by Jack D.
1249 | October 18, 2017 07:13:01 PM GMT
This will not be fixed for CF 10 as it is EOL
Comment by Vamseekrishna N.
1250 | October 23, 2017 09:55:16 AM GMT