tracker issue : CF-3339105

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

valueList() should take any expression that evaluates to a query column

| View in Tracker

Status/Resolution/Reason: To Fix//

Reporter/Name(from Bugbase): Adam Cameron / Adam Cameron (Adam Cameron)

Created: 09/29/2012

Components: Language

Versions: 10.0

Failure Type:

Found In Build/Fixed In Build: Final /

Priority/Frequency: Normal / Most users will encounter

Locale/System: English / Win All

Vote Count: 1

Problem Description:
valueList() only takes this exact syntax:
valueList(queryname.columnName)

That's stupid (yes, granted it's been stupid since Allaire owned CF, but that makes it stupid nevertheless).  It should simply take any expression that evaluates to a query column.

Steps to Reproduce:
function colours(){
	var colours = queryNew("");
	queryAddColumn(colours, "maori", "varchar", ["whero", "ma", "mangu"]);
	queryAddColumn(colours, "english", "varchar", ["red","white","black"]);
	return colours;
}
maoriColours = valueList(colours().maori);
writeOutput(colours().maori);

Actual Result:
error

Expected Result:
whero,ma,mangu

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3339105

External Customer Info:
External Company:  
External Customer Name: Adam Cameron.
External Customer Email:  
External Test Config: My Hardware and Environment details:

Attachments:

Comments:

+1, yeah I've ran into that limitation a number of times :(
Vote by External U.
17800 | October 02, 2012 01:54:03 AM GMT
This is flagged "to fix". When? Can you please be more communicative with this sort of thing? Add a comment, have a "fix version" field, etc. It's close to impossible to get useful tracking information out of this bug base.
Comment by External U.
17798 | December 09, 2014 02:44:22 AM GMT
*bump* (for answer to Adam's question)
Comment by External U.
17799 | September 26, 2015 09:57:34 PM GMT