QuotedValueList and column reference
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:346407 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: QuotedValueList and column reference
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