You may need to do something like this. The Evaluate function should give
it to you. The extra code is to explain, I hope it's clear, what I'm
evaluating.
<!--- Query for 1 record --->
<CFQUERY NAME="qGet" MAXROWS="1" DATASOURCE="#Application.DataSource#">
SELECT #Variables.FieldList# FROM SomeTable
WHERE company_id = '#Variables.Company_ID#'
AND transaction_complete = 0
</CFQUERY>
<!--- Create output reply to ERA.ColumnList:EfinData --->
<CFLOOP INDEX="i" FROM="1" TO="#ListLen(Variables.FieldList)#">
<!--- Set e-fin field name as EfinKey --->
<CFSET Variables.EfinKey = ListGetAt(Variables.FieldList, i)>
<!--- Set ERA field name as ERAField --->
<CFSET Variables.ERAField = StructFind(Application.Efin_To_ERA, EfinKey)>
<!--- Set individual field data as qGet query data --->
<CFSET Variables.EfinData = Evaluate("qGet.#Variables.EfinKey#")>
<CFOUTPUT>
#Variables.ERAField#:#Variables.EfinData##Variables.ASC13#
</CFOUTPUT>
</CFLOOP>
-----Original Message-----
From: Michel Gagnon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 03, 2000 4:43 PM
To: [EMAIL PROTECTED]
Subject: Setting a variable
Hi!
Is there a way to set a variable with the content of
another variable as part of the name.
Something like this, but that works.
<CFSet tempcat=#Cat.a#ID##>
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
