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

query of query order by column index giving error in CF 2021.

Explorer ,
Oct 06, 2021 Oct 06, 2021

Copy link to clipboard

Copied

I am getting error when I am using column index inside the Query of Query SQL. This is happening on Coldfusion 2021 and seems fine w/ Coldfusion 2016. Is this bug w/ Coldfusion 2021? THANKS!

<cffunction name="test" access="public">
    <cfquery datasource="myDS" name="local.getData" >
        SELECT email, first_name, last_name
        FROM users
    </cfquery>
    <cfquery dbtype="query" name="local.testQrySet">
        select email, first_name, last_name 
        from getData 
        where id=<cfqueryparam value="1919" cfsqltype="cf_sql_numeric" />
        order by 2 asc
    </cfquery>
    <cfdump var="#local.testQrySet#" />
</cffunction>

<cfset test() />

 

Views

431

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

Adobe Employee , Oct 06, 2021 Oct 06, 2021

Hello Joseph,

 

There is a fix available for this issue, please send an Email to cfsup@adobe.com for the fix

 

Thanks & Regards

Ravi

 

 

 

Votes

Translate

Translate
Adobe Employee ,
Oct 06, 2021 Oct 06, 2021

Copy link to clipboard

Copied

Hello Joseph,

 

There is a fix available for this issue, please send an Email to cfsup@adobe.com for the fix

 

Thanks & Regards

Ravi

 

 

 

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 06, 2021 Oct 06, 2021

Copy link to clipboard

Copied

LATEST

Allright. Thank you so much Ravi.

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