managed to get it working with the following: - Evaluate("QuotedValueList(theQuery." & columnName & ")")
> Hi, > > How can i reference a column in a QuotedValueList? > > For example: the following works fine: > > - QuotedValueList(theQuery.id) > > However, i need to reference the column instead of hard-coding it, the > following have all failed: > > <cfset columnName = 'id' /> > - QuotedValueList(theQuery['#columnName#']) > - QuotedValueList(theQuery.#columnName#) > > <cfset queryColumn = 'theQuery.#columnName#' /> > - QuotedValueList(queryColumn) > > thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346408 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm