#evaluate(collist)# will give you what you're looking for.
D
-----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
