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 dbtype="Query" name="secondquery" >
select * from firstquery
The second query does not return any results. There is nothing in the logs as well.
Does a CFDUMP of the first query produce records?
^ _ ^
And if not, are the datasources configured identically between CF10 & CF2016?