cfquery of query not working in CF2016

[danielw6790468]

I have a query which has run well on ColdFusion 10.

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>

The second query does not return any results. There is nothing in the logs as well.

[WolfShade]

Does a CFDUMP of the first query produce records?

V/r,

^ _ ^

[Carl Von Stetten]

And if not, are the datasources configured identically between CF10 & CF2016?

-Carl V.