Skip to main content
DReevesy
DReevesy
Participant
Dec 1, 2016 11:27 AM UTC
Question

cfquery of query not working in CF2016

I have a query which has run well on our old server. However we've upgraded to CF2016 and yet when I run a query of a query I get no results.

<cfquery datasource="travcomus" name="firstquery">

  SELECT * FROM tablename

</cfquery>

Followed by

<cfquery dbtype="Query" name="secondquery" >

  select * from firstquery

</cfquery>

Any ideas?

This topic is closed to new replies. Start a new post to keep the conversation going.

5 replies

WolfShade
WolfShade
Legend
Dec 1, 2016 5:11 PM UTC

Do you get absolutely nothing in return?  Or an error message?  Have the CFAdmin logs provided anything?

If you do a CFDUMP of both queries, does the second one show as empty?  Or that it doesn't exist?

I'm not at all familiar with CF2016, so I have to ask.

V/r,

^_^

Translate
DReevesy
DReevesyAuthor
Participant
Dec 1, 2016 5:13 PM UTC

It shows as empty and the CFAdmin logs aren't returning anything useful

Translate
WolfShade
WolfShade
Legend
Dec 1, 2016 5:21 PM UTC

Hmm..

Well, this probably isn't the response you were hoping for, but..  instead of using SELECT * (which honestly I despise), try selecting specific column names in both queries.  If that doesn't do it, and the CFDUMP  of the first query is providing the expected data, then my next move would be to check CF2016 documentation to assure myself that my QoQ code is correct.  If it is, then you may want to file a bug with Adobe at bugbase.adobe.com and see if anyone else either has a solution, or the dev team acknowledges it as a bug.

HTH,

^_^

Translate
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices