tracker issue : CF-4199727

select a category, or use search below
(searches all categories and all time range)
Title:

Query column values resolve incorrectly in a query passed as an argument to a CFC method

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/Fixed

Reporter/Name(from Bugbase): Dave Merrill / Dave Merrill ()

Created: 09/17/2017

Components: Language

Versions: 2016,11.0,2018

Failure Type: Incorrectly functioning

Found In Build/Fixed In Build: 2016,0,04,302561 / 308513

Priority/Frequency: Normal / All users will encounter

Locale/System: ALL / Windows 10 64 bit

Vote Count: 0

Problem Description: Query column values resolve incorrectly in a query passed as an argument to a CFC method. 
Inside cfloop, when a cfc method is passed a query as an argument, inside that method...
    arguments.query.CurrentRow is correct
    arguments.query.ID[arguments.query.CurrentRow] is correct
    arguments.query.ID without the arguments.query.CurrentRow qualifier always reads the first row, WRONG
Output directly from cfloop is correct, as is output from a local function, it's only wrong inside a CFC method. 

Steps to Reproduce: Navigate to the attached index.cfm file. It creates a query, then inside a cfloop, displays the value of a query column in different ways and in different contexts. 

Actual Result: arguments.query.ID without being qualified to the current row always reads the first row.

Expected Result: Current row value should always be read, since it's inside cfloop.

Any Workarounds: None I know of, except to qualify all column references ot the current row.

Attachments:

  1. September 17, 2017 00:00:00: demo.cfc
  2. September 17, 2017 00:00:00: index.cfm

Comments: