I've used this in the past:
SELECT *
FROM whatever
WHERE PersonID = '#evaluate("form.Person"&i)#'obviously i is the loop counter or something, depending on what you want to do with it.
Gorst, Nick wrote:
Hi Chad
use evaluate
I think the following syntax will work (I haven't tested it though).
#evaluate(MyVar&IndexNo)#
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Chad Renando Sent: Wednesday, 18 May 2005 1:14 PM To: CFAussie Mailing List Subject: [cfaussie] Dynamically Named Variables
What is the syntax please for creating dynamically named variables?
Say I dynmically created variables called MyVar1, MyVar2, etc..
I want to do something like:
<cfset IndexNo = 1> <cfloop query="MyQuery"> #MyVar##IndexNo# </cfloop>
Cheers,
Chad who looks on cbs.com before watching Survivor to see who gets voted off.
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
Please Note:
This communication has been sent on behalf of The Royal Automobile Club of Queensland Limited (RACQ). The information contained in this communication may be privileged and confidential. If you are not the intended recipient, any use, disclosure or copying of this communication is expressly prohibited. If you have received this communication in error, please delete it immediately. RACQ and its associated entities do not warrant or represent that this communication (including any enclosed files) is free from electronic viruses, faults or defects.
If this is a commercial electronic message within the meaning of the Spam Act(2003), you may indicate that you do not wish to receive any further commercial electronic messages from RACQ by sending an e-mail to [EMAIL PROTECTED] with your details or by contacting RACQ on 131905
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
--- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
