Ok wait still confused... Evaluate(WHAT?) For instance Evaluate(surname_Comm) doesn't work nor does Evaluate(#surname#_Comm) Sorry just not sure how to display it properly... Was using a CFSET tag like <CFSET surnamecomm = Evaluate(#surname#_Comm)> That gives an error <CFSET surnamecomm = "Evaluate(#surname#_Comm)"> Makes surnamecomm = to Evaluate(smith_comm) instead of just smith_comm I am probably missing something minor...
-----Original Message----- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 3:03 PM To: CF-Talk Subject: Re: Help with resolving a variable... 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> > ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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
