• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

cfquery of query not working in CF2016

New Here ,
Jan 30, 2018 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

424

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
community guidelines
LEGEND ,
Jan 30, 2018 Jan 30, 2018

Copy link to clipboard

Copied

Does a CFDUMP of the first query produce records?

V/r,

^ _ ^

Votes

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
community guidelines
Guide ,
Jan 30, 2018 Jan 30, 2018

Copy link to clipboard

Copied

LATEST

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

-Carl V.

Votes

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
community guidelines
Resources
Documentation