You want either...
qry_Query['#company#_visitdate']
Or...
qry_Query['#company#_visitdate'][RowNumber]
(Depending on context)
You could use this...
Evaluate("qry_Query.#company#_visitdate")
But I don't know anyone who would recommend that method.
> Hi,
>
> I want to output a dynamic column name.
> The example below doesn't work but I thought it might explain what I
> am trying to do the easiest.
>
> <cfset company = "acompany">
>
> (this here sets the name of the column to be returned)
> <cfset columntooutput = "qry_Query.#company#_visitdate">
>
> (this here returns the value from the database)
> #columntooutput#
>
> Thanks
>
Mark
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271656
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
