CFQuery value defined in name attribute is not returned when result is used

Description

When including the "result" attribute in a cfquery, the variable used in the "name" attribute does not get returned. Result should display information about the result and query call whereas the variable defined in "name" should return the actual data columns and rows.

When including result, Lucee will throw an error that the name variable does not exist. i.e.

<cfquery name="qryGetData" datasource="mydsn" result="qryGetDataResult">

Lucee will error saying qryGetData is not defined.

Environment

Linux

Activity

Show:
Pothys - MitrahSoft
yesterday

Pothys - MitrahSoft
April 15, 2021, 10:01 AM

I've checked this ticket with a fixed version and the issue was solved on that. So I marked this as deployed.

Dan Switzer, II
January 28, 2021, 3:11 PM

Any updates on when this fix might be released? We’re trying to migrate to Lucee and cannot until this bug is resolved. Thanks!

KabutoTX
November 10, 2020, 7:02 PM
Edited

Fixes my problem with Query.cfc failing but cfquery and queryexecute working (not using resultset on those).

https://dev.lucee.org/t/mssql-7-2-2-driver-exec-sp-not-working/7608

Pothys - MitrahSoft
November 4, 2020, 2:37 PM

I've checked this ticket with 's PR. Yes, it works fine now. cfquery name attribute returns the query when the result attribute is used. will confirm about this

Fixed
Your pinned fields
Click on the next to a field label to start pinning.

Assignee

Pothys - MitrahSoft

Reporter

Adam Webster

Priority

Major

Labels

Fix versions