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

CF2018 QoQ issue after update

Explorer ,
Oct 04, 2021 Oct 04, 2021

Copy link to clipboard

Copied

Hi,

We updated our CF servers over the weekend and since the update we've had errors coming in from an area with a Query of Queries is used. Basically there is an order by in the QoQ and this is the field not being returned. It should be returned and it was until we did the updates and for now I had to manually add the field back into the select statement. It should be returned via a select query.* from original but not working now. The only one missing though is the one used in the order by clause. Anyone had similiar issues?

 

Thanks

TOPICS
Advanced techniques , Database access , Server administration

Views

190

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

correct answers 1 Correct answer

Explorer , Oct 05, 2021 Oct 05, 2021

CF2018 Update 12. Reverted the code, added this new patch that was sent and everything worked again. 

Votes

Translate

Translate
Explorer ,
Oct 04, 2021 Oct 04, 2021

Copy link to clipboard

Copied

Contacted Coldfusion support and they've sent me a patch. Will deploy and post here as to how it goes. 

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
Community Expert ,
Oct 05, 2021 Oct 05, 2021

Copy link to clipboard

Copied

Just so we know, which update?

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
Explorer ,
Oct 05, 2021 Oct 05, 2021

Copy link to clipboard

Copied

LATEST

CF2018 Update 12. Reverted the code, added this new patch that was sent and everything worked again. 

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