Hiya Gina!
What you want to do is use the Evaluate() function.
So to normally just output the value of ACCT, you would just do:
<cfoutput>#ACCT#</cfoutput>
However, in your case you only get the actual name that holds the value returned from
your code, which is ACCT.
So to evaluate it, you would do:
#Evaluate(GetFromUAT.Columnlist)#
But, I assume (sorry if I am wrong) that the GetFromUAT.ColumnList will hold more than
1 value, all delimited by commas. So you must Evaluate(yourindex), where yourindex is
whatever name you give to the index attribute in your cfloop tag.
good luck!
- Andy
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 4:04 PM
> To: CF-Talk
> Subject: Getting the value of a variable, once removed
>
>
>
> I have this:
>
> <CFLOOP QUERY="GetFromUAT">
> <CFLOOP QUERY="GetColList">
> <CFIF (FindNoCase(COLLIST, GetFromUAT.Columnlist, 1)
> NEQ 0 OR OPTIONAL IS 0) >
> <TD>
> <CFOUTPUT>#COLLIST#</CFOUTPUT>
> </TD>
> </CFIF>
> </CFLOOP>
> </CFLOOP>
>
> The #COLLIST# variable contains the name of another variable (a
> table column name) which is the value I *really* need. I know
> this sounds confusing.
> Say the current #COLLIST# value is ACCT. What I really need is
> the value of #ACCT#, not ACCT (the value of #COLLIST#). Basically
> what I want to do is
> find out what
> columns were selected, and then display the value of the fields,
> not the name of the column (which is what I get now).
> The value of #GetFromUAT.Columnlist# would be something like this:
> ACCT,BMPRICE,BMREV,BMVOL,NETPRICE,NETREV,NETVOL
> The value of #ACCT#, for example, would be something like this:
> 0000493892847855103 ;
> the value of #BMPRICE# would be 34.48, etc.
> So, for each of the values in the #GetFromUAT.Columnlist#, I need
> the underlying value -
> (in the ACCT example, I actually need to return
> 0000493892847855103 (the value of #ACCT#), not ACCT (the value of
> #COLLIST#).
> I hope someone can understand this and help me out. I need a
> function like #TheValueOfThisValue(Var)#.
>
> Gina Shillitani
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
