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