Highlighted

cfquery of query not working in CF2016

New Here ,
Jan 30, 2018

Copy link to clipboard

Copied

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.

Views

354

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

cfquery of query not working in CF2016

New Here ,
Jan 30, 2018

Copy link to clipboard

Copied

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.

Views

355

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Jan 30, 2018 0
LEGEND ,
Jan 30, 2018

Copy link to clipboard

Copied

Does a CFDUMP of the first query produce records?

V/r,

^ _ ^

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jan 30, 2018 1
Most Valuable Participant ,
Jan 30, 2018

Copy link to clipboard

Copied

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

-Carl V.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jan 30, 2018 1