CF has a problem with CFLOOP QUERY= inside CFLOOP QUERY=
Refer to the entries via a FOR loop with
GetFromUAT.ColumnList[i]
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 05 April 2001 20:04
> 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
