Evaluate()
Use that to find the value of the vars you are dynamically building the names for
Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
---------------------------------------------------------
Macromedia Associate Partner
www.macromedia.com
----- Original Message -----
From: "Kelly Matthews" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 16, 2002 11:46 AM
Subject: Help with resolving a variable...
> Ok we have a survey where we have to rate each person in 3 categories.
> We have 50 people to rate.
> I set a comma delimited list of names and then create a loop to create 3
> questions
> for each person, so we can rate each of the 50 people in the 3 categories.
> Looks like this:
>
> <cfloop index="Surname" list="#ChunkLast#">
> <cfset ChunkFirstIndex = ChunkFirstIndex +1>
> <cfinput type="radio" name="#trim(Surname)#_Comm" value="1"
> style="background: white">
> <cfinput type="radio" name="#trim(Surname)#_Comm" value="2"
> style="background: BBE9FF">
> <cfinput type="radio" name="#trim(Surname)#_Comm" value="3"
> style="background: 9DCBFF">
> <input name="#trim(Surname)#_Comm_required" type="hidden" value="You forgot
> to rate <b>#trim(Surname)#</b> for <b>Committed to AAAE Goals,</b>">
>
> <cfinput type="radio" name="#trim(Surname)#_Cust" value="1"
> style="background: white">
> <cfinput type="radio" name="#trim(Surname)#_Cust" value="2"
> style="background: BBE9FF">
> <cfinput type="radio" name="#trim(Surname)#_Cust" value="3"
> style="background: 9DCBFF">
> <input name="#trim(Surname)#_Cust_required" type="hidden" value="You forgot
> to rate <b>#trim(Surname)#</b> for <b>Customer Service</b>.">
>
> <cfinput type="radio" name="#trim(Surname)#_Extr" value="1"
> style="background: white">
> <cfinput type="radio" name="#trim(Surname)#_Extr" value="2"
> style="background: BBE9FF">
> <cfinput type="radio" name="#trim(Surname)#_Extr" value="3"
> style="background: 9DCBFF"><cfinput type="radio"
> name="#trim(Surname)#_Extr" value="4" style="background: 5785FF">
> <input name="#trim(Surname)#_Extr_required" type="hidden" value="You forgot
> to rate <b>#trim(Surname)#</b> for <b>Extra Effort</b>.">
> </CFLOOP>
> It creates this part fine and as you can see for each category there are 3
> radio buttons all
> w/ the same name. So if the surname for the first person were smith the
> first set of radio
> buttons would be named smith_comm, 2nd set smith_cust, 3rd set smith_extr
> It does this for all 50 people, works great.
>
> Here is the problem when I hit submit I want to loop through to resolve all
> the values rather
> than have to type up 200 separate values in the insert statement.
>
> However if I want to loop through on the insert page similarly to how I am
> looping through on the
> form I can't resolve the variable. Because if I pass a value named
> smith_comm
> I can't loop through to get the value of smith_comm...
> Meaning an insert statement like:
> <cfloop index="Surname" list="#ChunkLast#">
> <cfset ChunkFirstIndex = ChunkFirstIndex +1>
> <CFQUERY datasource="SC2002">
> INSERT INTO SCORES
> (#trim(Surname)#_Comm)
> VALUES
> ('#trim(surname)#_comm') (obviously that won't work because it will
> insert a value of smith_comm instead of say "3" How do I find the value of
> smith_comm by looping through? Any ideas??
> </CFQUERY>
>
______________________________________________________________________
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
