I came across what is apparently an old Macromedia ColdFusion "bug" today in the valueList() function. The valueList() function will only accept a value where both the queryName and columnName are static values in the form: queryName.columnName.
It appears it'll throw an error if you try passing any other combination of equally valid syntax. For example, all of the below will throw an error, even though they are all valid references to a query and column.
valueList(queryName["columnName"]); valueList(queryName[dynamicValue]); valueList(evaluate("queryName.#dynamicValue#")); valueList(evaluate("queryName.columnName"#));
Even though all of the above are valid ways to references to a column in a query, they generate an error in ColdFusion MX v6.1 and 7.0. I've been told this will generate errors in even older versions of CF.
Fortunately, Raymond Camden has posted a UDF over at CFLib.org that you can use as a workaround. The function is called DynamicValueList().
NOTE:Interestly enough, BlueDragon does not apparently suffer from this bug—and it definitely is a bug in my book and not just a behavior issue. You should be able to pass in any valid reference to a column object to get a valueList() returned.
6 Comments
Comments for this entry have been disabled.