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

Reply via email to